Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Ling Xiang
    Please Save BI Answers Direct Database Query SQL Definition...
    Topic posted November 18, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI, Reports 
    114 Views
    Title:
    Please Save BI Answers Direct Database Query SQL Definition before 19D Upgrade
    Summary:
    Please save your BI Answers Direct Database Query SQL definition before 19D Upgrade
    Content:

    Please Note: This notice does not affect BI Publisher SQL data models and reports.

    Customers are strongly advised to save BI Answers Direct Database Query SQL definition before 19D Upgrade

    After 19D upgrade, you can continue to execute existing BI Answers Direct Database Query reports but you can no longer create, edit new reports or view report criteria.  You are strongly advised to review existing BI Answers Direct Database Query reports and save SQL definition for reports that need to be recreated in OTBI or BIP before 19D upgrade.

    Before 19D upgrade, you are strongly advised to save Direct Database Query SQL by using the following methods:

    • Open the report in Edit model, copy the SQL definition in the Criteria tab and paste the SQL statement in a text file and save the file.

    After 19D upgrade, you can no longer open Direct Database Query report criteria and can retrieve SQL from the report log file by using the following methods:

    • A user with BI Administrator privilege runs a Direct Database Query report. 
    • After the report runs, BI Administrator user clicks on Administration link, clicks on Manage Session, and clicks View Log for the executed report.  After log file opens, user copies and pastes the SQL statement in a text file and save the file.

    You must use this method to save BI Answers direct database query report definition before 20A upgrade as you will no longer be able to run BI Answers Direct Database Query after 20A upgrade. 

    If you have comments and concerns, please provide your feedback on this short OTBI customer survey.  Thank you for your time!

    Ling Xiang

    Oracle OTBI Product Management