Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Converting an OTBI report to a BIP report

Received Response
38
Views
3
Comments
Omran Zeaiter
Omran Zeaiter Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

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?

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    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.

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    @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

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    @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