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.
  • Tiina Pajulampi
    "My Team" results don't include my entire...
    Topic posted April 26, 2019 by Tiina PajulampiGreen Ribbon: 100+ Points, tagged OBIEE Answers, Reporting and Analytics in Reporting and Analytics for SCM Cloud public
    Title:
    "My Team" results don't include my entire organization
    Summary:
    How do I return data for everyone in my organization?
    Content:

    The predefined reports/tiles for "My Team*" only returns data for the level immediate below me, not sub-levels.  I.e. I'm a sales manager (or sales exec), in my organization hierarchy, I have two direct reports beneath me, and they in turn each have teams.  In my analysis, I want to return information, e.g. revenue, for my entire organization.  However, the filter by the predefined reports only return information for the two direct reports, and not the level below them.  The analysis uses this filter:

    "User Organization Hierarchy Based Login is equal to / is in  @{NQ_SESSION.USER_PARTY_ID}"

     How can I return data for everyone in my organization?

    Thank you!

    Tiina

    Version:
    OEC 19A, OBIEE 11.1.9.0
  • Amar
    'Payables Invoices - Holds Real Time' subject area...1
    Topic posted May 25, 2019 by AmarRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI in Reporting and Analytics for ERP public
    Title:
    'Payables Invoices - Holds Real Time' subject area has been obsoleted from 19b
    Summary:
    Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject Areas
    Content:

    Hi All--> Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject Areas.

    Oracle Transactional Business Intelligence 'Payables Invoices - Holds Real Time' subject area has been obsoleted and both header and line level hold information is now included in Payables Invoices - Transactions Real Time subject area.

    ? --> Have anyone been worked/developed on building a new OTBI report after 'Payables Invoices - Holds Real Time' subject area has been obsoleted and have included those information in "Payables Invoices - Transactions Real Time" subject area.

    Thanks

  • Linda Stelling
    'Publish for Subscription' in OTBI Agent4
    Topic posted February 27, 2019 by Linda StellingSilver Medal: 2,000+ Points, tagged OBI Answers, OBIEE Answers, OTBI, Report Delivery in General OBIEE public
    Title:
    'Publish for Subscription' in OTBI Agent
    Content:

    Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to notify recipients when an analysis has been run and data produced but not physically send it as an attachment (due to the inability to password protect the file).  I wondered if the Subscription functionality is the way to do this but I haven't really used it before so am a little unsure of what it's meant to do

    Apologies if this is documented somewhere obvious, I just can't seem to find anything. 

    Many thanks

    Linda

  • DTCC Admin
    .
    Topic posted January 11, 2019 by DTCC Admin, tagged OBIEE Answers, Setup, Setup/Administration in General OBIEE public
    Title:
    .
  • Andy French
    Able to change "Searching..." text?
    Topic posted July 13, 2016 by Andy FrenchGold Medal: 3,500+ Points, tagged Analyses, BI Publisher, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, Report Layouts, Reports in General OBIEE public
    Title:
    Able to change "Searching..." text?
    Summary:
    Able to change "Searching..." text?
    Content:

    Are we able to change the text on the "Searching..." pop up that appears when an analysis is loading? See attached. We have some reports that are very large and take several minutes to load. Ideally, I'd like the message to say "Running. Report may take a few minutes to load."

     

     

     

     

     

    Image:
  • Ravikiran K P
    Access OTBI Data without Job Roles3
    Topic posted January 8, 2018 by Ravikiran K P, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Access OTBI Data without Job Roles
    Summary:
    For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?
    Content:

    Hey Guys,

    We were checking to see if there is a way for OTBI Admins to access the reports/data as a Super User without having the Specific Job roles (like Inventory Manager, Warehouse Manager etc) assigned.

    We tried assigning all the %TRANSACTION_ANALYSIS_DUTY roles, but aren't able to access the data without Job Roles assigned. Any thoughts?

    Thanks,

  • MShrini
    Actual Cost is showing 0 in Project OTBI reports after R12...Answered9
    Topic posted August 31, 2017 by MShriniGold Trophy: 10,000+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Actual Cost is showing 0 in Project OTBI reports after R12 upgrade
    Summary:
    Actual Cost is showing 0 in Project OTBI reports after R12 upgrade
    Content:

    Hi,

    We are facing an issue like Actual costs are showing '0' for Project Analytics (OTBI) reports.  Please let me know if any one faced similar issue after upgrade/P2T earlier and got the solution.

    Thanks,

    Srini.

     

     

  • Lak
    Add Account Parmeter to Custom BI Puslisher Report1
    Topic posted December 10, 2018 by LakRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Add Account Parmeter to Custom BI Puslisher Report
    Content:

    Hi Friends,

    I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create parameter. Could you please let me know the process for adding account(GL_CODE_COMBINATIONS - SEGMENT1to7) parameter to custom BI Publisher report.

    Appreciated your quick help..!

    Thanks

    Lak

    Version:
    ORACLE CLOUD ERP R13
  • Richard Beet
    Adding and embedding BI content into Fusion Cloud...28
    Topic posted August 15, 2017 by Richard BeetRed Ribbon: 250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding and embedding BI content into Fusion Cloud Applications
    Summary:
    Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content into
    Content:

    Hi All,

    Our client wants to be able to add some BI content to the Payables > Invoices page in Oracle Fusion Financials Cloud. Ideally they would like to add their own custom Infolet-like report to this page, but I am not sure this is possible...

    I was thinking that a potential option would be to use the Page Integration wizard to add a new tab to the Payables > Invoices page and include a custom BI report that displays the desired information.

    I have setup the tab in the Page Integration wizard and have confirmed that the new icon appears to the left of the Payables > Invoices page. However, when I go to Customize Page and select 'Add Content', it is not providing me with the option to select a report from the Oracle BI Presentation Catalog.

    - Does anyone know if we can embed BI content on this page?

    - Does anyone have any guidelines on exactly which pages we can add/embed BI content to in Fusion Cloud Applications?

    Thanks,

    Richard