Issue when using Report prompts within OTBI Answers and OTBI Fusion

A strange Issue exists with OTBI in terms of Report prompts. If a User adds a prompt directly within the Report, the prompts appear correctly within BI Answers. However, if the same Report is opened from within Oracle Cloud, the prompts are not shown to the User.

Prompts added to Report:

image

Prompts appearing in BI Answers of OTBI when running (opening) the Report:

image

However, when opening the same Report from Fusion (OTBI embedded) the Report executes without showing the prompts, even though the prompt has been specified as “required”:

image

When clicking on the “Edit” button of the Fusion Catalogue Browser, the following warning message is being displayed:

image

The standard provides prompted Analysis usually of Type “Dashboard”, hence this Issue is not applying for standard content. E.g. the Analysis on Department details also provides filters as Dashboard prompts:

image

Advertisements

Translation of multi-lingual attributes within Oracle Fusion Cloud and OTBI

Oracle Fusion Cloud allows to enable text fields as multi lingual enabled attributes. As part of the batch upload process e.g. from Fusion Product Hub, these enabled attributes can be specified within different languages:

image 

Within Oracle Fusion Cloud, these attributes are displayed in  the respective Language of the logged in User. These is also true for OTBI. E.g. for US the respective item description is displayed in US:

image

If a user logges into OTBI with RUS language, the item description is automatically displayed with RUS description:

image

understanding calculation for Days of Absence

To Analyse the Days of Absence for Workers, the Absence information is extracted and loaded into a dedicated Star (W_ABSENCE_EVENT_F) of the BI Applications data model. A simple Report on the days of Absence and absence occurrences looks like the following from the Report Builder (Answers):

image

This can also be restricted to a individual worker and a specific time period by applying additional filters in the Report Builder:

image

This Report then return the following filtered results:

image

This is based on the Fact for Absence:

image

The Absence Days are calculated based on the DAYS_DURATION column for the selected period from 2017/07/06 until 2017/07/17. Thus, each duration will be counted for the selected period regardless of the start or end date of a an Absence event (First column). If the worker was not scheduled to work of a certain days such as 7.7. and 8.7. then these days will not be counted as days of Absence. The Absence occurrences are calculated on the ABS_OCCRNC_DAY column.

How to create a direct database query with OTBI?

Within Oracle Fusion OTBI go to New > Analysis and click on Create Direct Database Query:

image

Within the Editor the connection Pool information needs to be entered:

image

The following connection pools can be entered:

  • HCM – “HCM_OLTP”.”Connection Pool”
  • CRM – “CRM_OLTP”.”Connection Pool”
  • FIN and PROC – “FSCM_OLTP”.”Connection Pool”

After that, a query may be entered for direct database execution on the Oracle Fusion Cloud (bundled) Database (identified by the Connection pool supplied before):

image 

For a listing of all Physical Tables please refer to (only available for HCM): https://cloudcustomerconnect.oracle.com/posts/ac54c31fcf 

This contains a Excel mapping with the Physical OTBI Tables:

image

 

For a full support note please refer to: How To Create A Report with Direct Database Query in OTBI/OBIEE Analysis, Who Can Access Direct Database Query (Doc ID 2141412.1)

For a similar approach using BI Publisher please check:  Creating a BI Publisher Report using SQL Query in Oracle Fusion HCM Cloud

To check the general TechNote for OTBI and Fusion HCM, please refer to: Oracle Fusion HCM: Resources for Oracle Transactional Business Intelligence (Doc ID 2023155.1)

BI Publisher and BICS?

Within the on-Premise World BI Publisher (BIP) was bundled with Oracle BI EE (OBIEE). However, the respective Oracle BI Cloud Service (BICS) does not come with a bundled Version of BI Publisher as Cloud Service.

A user may only choose one of the following options to create new items:

image 

However, Oracle Transactional Business Intelligence (OTBI) does come with a bundled Version of BI Publisher. Once the User logs into OTBI, the following options are available to create new Analytical items:

image

For further reference check Oracle Support note: Is BI Publisher (BIP) Available as part of BICS (Doc ID 2104841.1)

Link

Link to information about business questions and answers for Oracle Transactional Business Intelligence (OTBI) Embedded Analytics Cloud, HCM Subject areas:  http://www.oracle.com/technetwork/documentation/otbi-hcm-2225528.html

And for OTBI-E subject areas. The advantage of this is, that it is indeed very similar to Oracle BI Applications (OBIA) and can easily be applied for the same:

http://www.oracle.com/technetwork/documentation/otbi-e-2247768.htm

Oracle Data Cloud: What Oracle knows about you..

As described in a previous article, many website connect and forward visitor information to other Parties in order to Analyse and Understand the Website visiting pattern. The best and probably well-known example is Facebook. Even when visiting another website, Facebook is often called in the backend by the web site e.g. by a hidden hyperlink or hidden pixel (which needs to be downloaded from Facebook) and by this Facebook receives the information that the respective website has been visited. Using this information, it is possible to create a certain profile of the Visitor in terms of interest and other attributes, which can be used for Target Marketing campaigns. While Facebook is well-known, Oracle also has a large presence within the Marketing World and acquired the data (profile) provider Bluekai, which is now called Oracle Data Cloud. This information can also be integrated with the Oracle Marketing Cloud (formally Eloqua) for the creation of Marketing Segments and Campaign execution.

Every User can also check the information kept about himself by visiting: http://www.bluekai.com/registry-de/ 

image