Hi In OTBI , We can create Analysis based on the predefined Subject Area which provide solution for certain Scenario and queries. For Example Workforce Management - Worker Assignment Real Time Business Questions This subject area can answer the following business questions: What are the various reasons for worker…

Hi Scott, Hope this helps Q What is Bursting ? A Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations Below is a step by step use case to explain the process Steps 1. Create a Data Model with a bursting Query a. Create a Data Set…

The document is really helpful.

In OTBI , if the report need to be viewed without any delivery then ,Click on the Open Option (which allows to view the report in online) and it can be exported into exported format (Excel, CSV, etc ) There is no such Repository present in OTBI as the Report Job History Page in BI Publisher. In case if the motive is to…

Hi Jonathan, Kindly look into the below points which can resolve the issue 1. Append the query with "Where rownum < 20 " in the data Model (For testing Purpose) 2. Secondly Add parameters to the Data Model so that you can run the report based on valid parameter values 3. Schedule the Report Thanks

Hi Rahul, Kindly use conditional statements (If) for the table which holds Country ,Group And Case Code . The condition logic should be based on Total revenue Column (Total revenue not equal to zero or greater than zero) Thanks

Kindly use the the below table to get most of the required data GL_FRC_REPORTS_B Hope this helps

As part of Workaround Different layouts can be created in a single BI Publisher Report which can accommodate different views of the data extracted from the same Data Model