Reference variable expressions within Oracle BI Answers

Variables such as System or Session can be referenced witin Oracle BI Answers. To reference a variable with a expression, the following syntax is available for referencing the Login User Name:


@{user.displayName}{default}

@{biServer.variables['NQ_SESSION.USER']}

This can be used within a Narrative View to display information about the current User or Session:

image

The following can be used as example:


[b]User Name:[/b] @{user.displayName}{default} <BR>
[b]User Name:[/b] @{biServer.variables['NQ_SESSION.USER']} <BR>
[b]Roles:[/b] @{biServer.variables['NQ_SESSION.ROLES']} <BR>
[b]Group:[/b] @{biServer.variables['NQ_SESSION.GROUP']} <BR>
[b]Group:[/b] @{biServer.variables['NQ_SESSION.WEBGROUPS']} <BR>

image

For further reference, check the official Documentation:

Advertisements

OBIEE: BY clause for group by

Within Oracle BI Answers (and only within BI Answers and not within the Metadata model), the BY clause can be used in conjunction with a Aggregate function to specify the level at which the metric should be aggregated (group by).

As an Example, the following Analysis displays the shipped amount per Year and product type:

image

Within certain scenarios, it may be useful to add a level of aggregation at a particular leve within a Report. This can be achieved with the BY clause. This clause can be added with a Aggregation function such as MIN, MAX, SUM etc. within the BI Answers formular editor:

image

SUM("Base Facts"."7- Shipped Amount" BY "Time"."T05 Per Name Year")

This, creates a group by for the measure at the level of Year, regardless of other aggregation levels intented by the Report e.g. at the level of produt type:

image

This clause should only be used with caution for possible incorrect or unintended results.

detecting Report (Analysis) Orphans in OBIEE

A Dashboard typically represent a combination of different Reports to provide summary information about a Business Process or Sub-Process e.g. with HR: A Recruiting Dashboard may contain Reports about hiring sources and the respective Time to Hire or a Dashboard provides Reports about certain balance information E.g. current capital in Fixed Assets. Over time these Reports may be replaced or exchanged and many reports may only be created for Testing purposes. The management of all these Reports becomes very difficult and the IT Department may want to understand the structure of the Web Catalog in terms of Report usage on Dashboard and Report Orphans. The Oracle BI Sample App provides a example of how this can be implemented under the Lifecycle and Admin section:

image

 

Pre-built Reports exist that Analyse the structure of the Webcat to determine unused Analysis:

image

These samples require to execute scripts on the BI instance, which is also documented within the Sample App Image under /app/oracle/SAScripts/ReferenceChecker.

changing the default data type of number formats

to change the default format used by the Oracle BI EE 11g the following configuration file needs to be changed:

/home/oracle/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/root/system/metadata

image
E.g. for two digits behind the number separator:

<dataFormat minDigits="2" maxDigits="2" commas="true" 
negativeType="minus" xsi:type="saw:number";

After saving and restarting the BI Server, the numbers are displayed with two digits behind the number separator.

Oracle BI 12c: fixing wlst.sh installation issue

While trying to install Oracle BI 12c we were facing an Issue during the Configuration of the Oracle BI Domain on the Weblogic Server. This is typically the last step of the Installation where the Domain is configured and started.

During the Installation we received the following Error Message:

BI Configuration
Error
Config Action BI Configuration failed

Configure BI Failed with Execution of [/opt/biee/oracle_common/common
/bin/wlst.sh, /opt/biee/bi/modules/oracle.bi.configassistant/
complete_domain.py,
/opt/biee, /opt/biee/user_projects/domains/bi, weblogic, Expanded,
serverhostname.lasg, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver,
jdbc:oracle:thin:@//hostname:1521/DBservice.world, DEV,
jdbc:oracle:thin:@//hostname:1521/DBservice.world, ]
failed with exit value 1

When checking the detailed log files at the following location:

/home/Linuxuser/oraInventory/logs/config2017-03-06_03-26-26PM/biee.log

The log file also didn’t reveal much more:

Failed single shot step: Complete domain with: Execution of [/opt/
biee/oracle_common/common/bin/wlst.sh, /opt/biee/bi/modules/oracle.bi.
configassistant/complete_domain.py, /opt/biee, /opt/biee/user_project
s/domains/bi, weblogic, Expanded, serverhostname.lasg, 9502, 9503,
ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//hostname:1530/
DBservice.world, DEV, jdbc:oracle:thin:@//hostname:1530/DBservice.
world, ] failed with exit value 1

After verifying that the ports are not blocked by the firewall we found some similar Issue with the Oracle BI 12c Installation. By adding the following Parameter to the wlst.sh file we were able to fix this Issue, too.

JVM_ARGS="<strong>-Djava.security.egd=file:///dev/urandom</strong>
${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}"

<span style="font-family: Courier New;">if [ -d "${JAVA_HOME}" ]; then
eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} weblogic.WLST '"$@"'
else
exit 1
fi

image

After deleting the Domain Installation files within the User Project (Domain Folder):

e.g. /opt/biee/user_projects/domains/bi

And dropping the Internal Repository Tables using the RCU routine the Domain Installation step “Configure Domain” succeeded without the above error.

image