Converting an OTBI report to a BIP report

Question

I have an OTBI report that is causing an access error for the user. Could we convert this report to a BIP report and remove any access restrictions to ensure it functions properly?

Riyaz Ali-Oracle · Answer

@Omran Zeaiter

You can try the below:

1.Extract the OTBI Report SQL

Open the OTBI report and navigate to Advanced.

Copy the Logical SQL or Physical SQL used in the report.

2. Create a New BIP Data Model

Go to Reports and Analytics → Browse Catalog.

Click New → Data Model and select SQL Query as the data source.

Paste the SQL extracted from OTBI and validate it.

3. Design the BIP Report Template

Create an RTF, Excel, or PDF template using the BI Publisher Add-in.

Map the fields from the data model to the template.

4. Adjust Security Settings

Navigate to Reports and Analytics → Browse Catalog.

Locate the BIP report, click Permissions, and modify access settings.

Ensure that restricted users have the necessary roles to view the report.

Please review below doc for more details:

Convert OTBI analysis / report to BI Publisher report — Cloud Customer Connect

Convert OTBI Analysis into BIP Report — Cloud Customer Connect

Fusion Applications OTBI and BIP: How To Migrate BI Catalog content such as custom BI Dashboards, Analyses and BIP Reports From One Instance To Another Instance ? (Doc ID 1572602.1)

Thanks,

Riyaz Ali

Gaurav Bharadwaj-Oracle · Answer

@Omran Zeaiter

There is no way to "Convert" an OTBI analysis to a BIP Report.

If you can tell us more about the error or issue you are facing, we can advise further.

Additionally, if you would like to recreate the analysis but using a data model using SQL.

Then what you need to do is the following :

1) Find the Data Lineage Mapping document for the Subject Area you had used to make the analysis.

2) In the Mapping document, you will find the the database table and column names against each of the subject area columns.

3) You can then use this information to build an SQL query choosing the same columns as the OTBI analysis.

Data Lineage document for all applications in Fusion can be found using the following navigation :

Go to :

https://docs.oracle.com/en/

Select the appropriate fusion product(Example Financials) → Click on it

Find "Analyze and Report" on the subsequent page → Click on it

Find "Review data lineage" on the subsequent page → Click on it

This will take you to the right documentation.

If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

Regards,

Gaurav

Nathan CCC · Answer

Hi Omran, What is this access error? If you bypass data security then the outcome is the opposite. What you have done is made it so that it does NOT function properly. To function properly a user must view only data for which they are authorized to view.

It you replace an analysis in OTBI with a report in OTBI with a data model with a data set which does not query a subject area but bypass data security to query direct the tables and views without any data security - then you have not solved the requirement. User may view data they are not allowed to view.

In my opinion a better solution is to setup this user with the required data access so that  they can view what they need to see in either 1) an analysis in OTBI or 2) in a report in OTBI with a data model with a data set that query the subject areas using data source Oracle BI EE or data set of type analysis.