Posts

Posts

  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown44.6
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    R13.18A OTBI BI Catalog Lockdown
    Summary:
    With 13.18A release customers will no longer be able to modify the shipped BI catalog content.
    Content:

    R13.18A OTBI Product Alert

    This product alert is published by Oracle OTBI Product Development.

    Release 13.18A Factory BI Catalog Lockdown

    To minimize upgrade regression, an enhancement has been introduced in the 13.18A release to permanently make the shipped BI catalog content read-only.  If users attempt to modify the shipped BI catalog content including folder permissions, they will receive an alert "You are not allowed to modify factory content. Save your own content in /Shared/Custom."  Customers that upgrade from R12 to R13 will no longer be able to make changes to the delivered BI catalog even with BI Administrator role. Starting with R13.18A, BI catalog folders will behave as follows:

    • Customers must save all custom content in /Shared/Custom folder or create new sub-folders under /Shared to maintain custom content.
    • Except for /Shared/Custom folder, customers can no longer make any modifications to the delivered BI catalog. If a user attempts to add, change or remove any object including permission list in the delivered catalog folder, he/she will get an error "You are not allowed to modify factory content. Save your own content in /Shared/Custom."
    • Customers are permitted to retain EXISTING custom top-level folders under Shared. All existing content in those top-level custom folders will be preserved.
    • Customers cannot add, remove or change permissions on the shipped folders, e.g. /Shared/ Human Capital Management
    • Customers cannot modify the folder permissions to 'hide' the shipped factory catalog folder, e.g. hide /Shared/Marketing.
    Impact on R12 upgrade customers:
    • For customers upgrading from R12, all existing custom content in /Shared/Custom or custom folders under /Shared and their sub-folders will remain as they are.  However, if customers have modified the content in the delivered BI catalog folders, e.g. added custom reports, modified delivered reports, modified folder or report permission, all changes to this content will be lost after the R13 upgrade.  Customers are advised to archive their custom BI catalog to a file prior to R13 upgrade; and after R13 upgrade customers can unarchive the custom projects in the /Shared/Custom folder.  

     

    • Fusion application users are auto-provisioned with BI Consumer role, which allows them to read and traverse the BI catalog folders. This access is for folder viewing and navigation only and doesn't give the user the privilege to view, open, edit and execute BI reports, for which the user has no security authorization. An enhancement is in development to restrict access to BI catalog folders such that a user will no longer be able to see and traverse BI catalog folders that he or she has no security authorization to access.
  • Ling Xiang
    R13 Financials OTBI subject area to database lineage mapping...334.8
    Topic posted August 4, 2017 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    R13 Financials OTBI subject area to database lineage mapping spreadsheet
    Summary:
    This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security.
    Content:

    This spreadsheet is published by Oracle OTBI Development.  This spreadsheet documents Fusion Financials OTBI subject areas, the corresponding View Objects and database tables and columns.  Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.  

    This spreadsheet also documents subject area security duty roles and job roles.

    The spreadsheet applies to Financials R13. 

  • Andy Gough
    OTBI Dashboard and Reports for Expenses155.0
    Topic posted December 23, 2016 by Andy GoughBronze Medal: 1,250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Dashboard and Reports for Expenses
    Summary:
    An OTBI dashboard with a series of drillable reports for Expenses
    Content:

    The attached catalog files can be imported into an ERP Cloud instance to create a dashboard with a series of drillable reports for expenses. Please see screenshot and attached files for details on how to use the dashboard, and how to import it into your environment.

    Enjoy!

    Andy

    Image:
  • Ling Xiang
    R12 ERP OTBI subject areas to database tables mapping...104.9
    Topic posted March 30, 2017 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    R12 ERP OTBI subject areas to database tables mapping spreadsheets
    Summary:
    R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheets
    Content:

    These spreadsheets are published by Oracle OTBI Development.  These spreadsheets document Fusion Financial and Supply Chain Management OTBI subject areas and the corresponding View Objects and database tables and columns.  Customers can use these spreadsheets to search for reporting fields in OTBI subject areas or trace the lineage from subject areas to database tables, columns and view objects or vice versa.  

    The spreadsheets apply to Fusion ERP and SCM Release 12.

    Please note In R12 users can search for a field in a subject area in OTBI.

  • Andy Gough
    OTBI Report for AP Invoice Holds94.9
    Topic posted August 16, 2016 by Andy GoughBronze Medal: 1,250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Report for AP Invoice Holds
    Summary:
    Sample OTBI report for ERP Cloud providing a list of AP Invoices on Hold
    Content:

    Sample OTBI Report for ERP Cloud: AP Invoices on Hold

    This report provides a list of AP Invoices currently on hold, as per the screenshot below.

     

    Instructions to Deploy in Your Environment:

    1. Create a new empty OTBI report, using any Subject Area – don’t bother to add any columns to your report
    2. In the Report Editor, go to the “Advanced” tab
    3. Clear the text from the “Analysis XML” box
    4. Paste the contents of the attached file “AP Holds Report.txt” into the “Analysis XML” box and click the “Apply XML” button
    5. Go back to the “Results” tab and you should see the report
    6. Save the report
    Image:
    Document:
  • Ling Xiang
    R11 ERP OTBI Subject Area Mapping to Fusion Database Tables144.9
    Topic posted June 6, 2016 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI in Reporting and Analytics for ERP public
    Title:
    R11 ERP OTBI Subject Area Mapping to Fusion Database Tables
    Summary:
    Release 11 ERP OTBI subject area database table mapping spreadsheet
    Content:

    This spreadsheet is published by Oracle OTBI Development.  This spreadsheet documents Fusion ERP OTBI subject areas, columns and the corresponding HCM database tables and columns.  Customers can use this spreadsheet to search for subject area reporting content or trace the corresponding database table and column for a subject area reporting field.

    The spreadsheet applies to Fusion ERP Release 11.

     

  • Tu Lam
    R13 SCM and Procurement OTBI subject area Description...14.9
    Topic posted August 18, 2017 by Tu LamBronze Medal: 1,250+ Points, tagged Asset Tracking, Costing, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, OBIEE Answers, Order Management, OTBI, Pricing, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Quality – Issues and Actions, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM public
    Title:
    R13 SCM and Procurement OTBI subject area Description documentation
    Summary:
    R13 SCM and Procurement OTBI subject area Description documentation
    Content:

    This documentation is published by Oracle OTBI development.  This document provides users a functional understanding of SCM and Procurement subject areas - what they contain, key business questions that can be answered with the analyses built using the subject areas, the primary navigation paths in the application UI that contain information related to specific subject areas, and other useful information.  This document also contains information on the duty and job roles that provide access to each subject area.
     
    The spreadsheets apply to SCM and Procurement R13.

  • Ling Xiang
    New OTBI Help Landing Page5.0
    Topic posted October 9, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    New OTBI Help Landing Page
    Summary:
    Introducing a brand-new OTBI Help Landing Page
    Content:

    This e-mail is sent by Oracle OTBI product management.

    Starting with Release 13.18.10, a brand-new OTBI Help landing page is available -> https://docs.oracle.com/en/cloud/saas/business-intelligence/index.html.  From an OTBI 18.10 instance (or a later release), users can click on the ‘OTBI Help’ link in Answers and launch the OTBI Help landing page.  This page is a quick launch pad to relevant OTBI help documents – subject area guide, data lineage, report list and OTBI product Help.  Users can also book mark the OTBI Help landing page and launch it directly from a browser.  The OTBI Help landing page will save users from having to go to different places to locate OTBI help.  

    The subject area guide is a new tool that gives users helpful information on how to use a subject area, related business questions, and security roles.  The hyper-linked subject area guide replaces the subject area description spreadsheets that OTBI product management have published in Customer Connect.  

    We welcome your feedback on the new OTBI Help landing page and suggestions on improving OTBI help and usability.

    Image:
  • Dustin Grabowski
    Sample Report: Project Financial Management Cloud: Project...125.0
    Topic posted November 15, 2016 by Dustin GrabowskiGold Medal: 3,500+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Sample Reports in Project Management public
    Title:
    Sample Report: Project Financial Management Cloud: Project Budget vs. Actual
    Summary:
    This dashboard displays Budget details for a specific project.
    Content:

    The attached sample dashboard displays budget vs. actual cost and commitment details for a specific project.  Drill down pages show details of the actual costs and commitment transactions.

     

    To add this report to your environment:

    1. Save the catalog to a local folder

    2. Unarchive it to the OTBI web catalog under Shared Folders - Custom - Projects

    3. In the folder called ''Budget vs. Actual Reports', open the dashboard called 'Project Budget vs Actual'

     

    Fusion Applications: 11.1.1.11.0+

    Subject areas used: Projects - Cross Subject Area Analysis Real Time

                                  Project Costing - Actual Costs Real Time

                                  Project Costing - Commitments Real Time

    5 minutes to copy into your environment.

    Image:
  • Ling Xiang
    R13.19A OTBI Direct Database Query Privilege Change64.6
    Topic posted February 6, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged OBIEE Answers, OTBI, Reporting and Analytics in Reporting and Analytics for SCM public
    Title:
    R13.19A OTBI Direct Database Query Privilege Change
    Summary:
    In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to revert this change.
    Content:

    What is the Change?

    Prior to R13.19A, BI Administrator has the privilege to create and run Direct Database Query in BI Answers.  In R13.19A, this feature has been disabled by default.  Specifically, two privileges that control direct database query access, namely ‘Edit Direct Database Analysis’ and ‘Execute Direct Database Analysis’,  have been denied for authenticated users. 

    Reports created with ‘Direct Database Query’ option prior to R13.19A will receive a system error when executed in R13.19A.  To prevent the system error, customers can revert the R13.19A privilege changes by granting BI Administrator privilege to both ‘Edit Direct Database Analysis and ‘Execute Direct Database Analysis’.  

    Please note: This change does not affect BI Publisher SQL reports created with BI Publisher Data Model or BI Answers reports created with Logical SQL.

    How to revert the change?

    BI Administrator can modify direct database analysis privileges in BI Administration -> Manage Privileges page.  To grant BI Administrator access to direct database query, customers can remove ‘Authenticated User’ that has ‘Denied’ permission from the seeded privileges and add a new role of ‘BI Administrator Role’ with ‘Granted’ permission. 

    Repeat the same step to grant ‘BI Administrator Role’ to ‘Execute Direct Database Analysis’ privilege.  

    Future Product Direction

    Direct database query is not a supported OTBI feature for building reports.  Customers are encouraged to use BI Answers to create interactive analyses, use BI Publisher for fixed-format reports and use BI Cloud Connector (BICC) for data extraction.  If customers have created OTBI reports with Direct Database Query option, Oracle development strongly recommends migrating those reports to use OTBI subject areas as Direct Database Query will be deprecated in OTBI in 12 months. 

    Please refer to attached document for more detailed information.  If you have further questions, please contact Oracle Support.