Link

OAC Blog: https://blogs.oracle.com/analyticscloud/

Blog series on machine learning with OAC: https://blogs.oracle.com/analyticscloud/machine-learning

Advertisements

ODI 11g and Java location

Oracle Data Integrator 11g requies Java to run and install. This is required when performing the installation from setup.exe of location ofm_odi_generic_11.1.1.9.0_disk1_1of2\Disk1. Depending on your system, the Install may show the following error:

Error: Provide the JDK/JRE location while launching the installer. Invoke the setup.exe with –jreLoc

with below Error Message:

image

The JDK location needs to be specified while running the setup.exe from a MS-Dos (CMD) Window. However, the path may not contain any spaces! If Java has been installed in the default location like C:\Program Files\Java\ , then the path must be expressed like C:\Progra~1\java\ while invoking the setup.exe:

C:\Users\****\Downloads\ofm_odi_generic_11.1.1.9.0_disk1_1of2\Disk1>setup.exe -jreLoc C:\Progra~1\java\jdk1.8.0_171

image

This will then allow the installer to run properly.

image

Downloading a rpd from OAC Thin Client Modeller

The web modeller or Thin Client Modeller was introduced with BICS and OAC respectively, to allow a more agile metadata modelling. The thin Client modeller does not provide the same level of modelling functionality compared to the “classic” .rpd metadata model. Additionally, with the current release of OAC only one modelling approach is supported. Thus, only the thin client model or the classical model can be deployed as metadata at a time.

Hence, the might be a scenario for switching from the thin client modeller (web modeller) to the classic .rpd model to support more complex metadata modelling.

A .rpd file can be generated from OAC when downloading a Snapshot and extracting the .bar file. The .bar file can be downloaded from the Snapshots area of the OAC Console:

image

When clicking on a option menu right to the Snapshots, the Console allows  to download the snapshot as .bar file. Once the .bar file is downloaded (after assining a password to protect the downloaded file), the file can be opened with a Archive Tool such as 7z.

image

The .rpd data model can be opened like any other classical metadata model using the BI Administration Tool. This will contain system generated Objects and Names:

image

Referencing Oracle BI System Session variables

Oracle BI (OBIEE) provides multiple categories of Variables, such as:

  • Session
  • Repository
  • Presentation
  • Global

These different categories of variables need to be referenced using a specific syntax. However, the required syntax depends on the category of variable and the context. Below are examples for referencing Session variables in Analysis/Reports and within the narrative View. This is often useful for debugging scenarios or for performing unit test when creating complex formulas.

To reference a Session Variable within a Report use: VALUEOF(NQ_SESSION.GROUP) like below:

image

To reference a Session Variable within a Narrative View use: @{biServer.variables[‘NQ_SESSION.GROUP’]} like below:

image

The complete code to reference the different Session variables (User, Group, Roles) is as follows:


[b]Derzeitiger User:[/b] @{biServer.variables['NQ_SESSION.USER']} [br/][br/]
[b]Derzeitiger Anzeigename:[/b] @{biServer.variables['NQ_SESSION.DISPLAYNAME']} [br/][br/]
[b]Derzeitiger Gruppen:[/b] @{biServer.variables['NQ_SESSION.GROUP']} [br/][br/]
[b]Derzeitiger Rollen:[/b] @{biServer.variables['NQ_SESSION.ROLES']} [br/]

For a exessive list of available Session variables check:

For general Overview check:

For short reference card check:

For Official Documentation check (11g):