Posts

Posts

  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown5.0
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, BI Publisher Reports, OTBI, Reporting and Analytics, Sample Reports in Reporting and Analytics for SCM Cloud 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.18A OTBI BI Catalog Lockdown24.7
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Reporting and Analytics in Engagement Cloud > Reporting and Analytics for Engagement Cloud 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.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.
  • Nagesh Manda
    Reporting Options to replace Discoverer Reports1
    Topic posted Yesterday by Nagesh MandaSilver Medal: 2,000+ Points, tagged BI Publisher, Business Intelligence, Data Sync, OAC Enterprise Edition in Business Analytics > Business Intelligence public
    Title:
    Reporting Options to replace Discoverer Reports
    Content:

    Hi All,

    Our customer is looking for some reporting options to migrate their real time reports from Discoverer.

    I have found a MOS note (Oracle Business Intelligence Discoverer Statement of Direction - March 2014 (Doc ID 1634827.1) which seems to be pretty old. Could you kindly provide some inputs around  the Oracle Products which can be help the customer to move away from Discoverer.

    Thanks,

    Nagesh.

  • Amitabha Dutta
    How to pass ESS requestid to BIP report4
    Topic posted July 18, 2019 by Amitabha DuttaGreen Ribbon: 100+ Points, tagged BI Publisher in Business Analytics > Business Intelligence public
    Title:
    How to pass ESS requestid to BIP report
    Summary:
    Is it possible to pass the ESS job id/process id/requestid as a parameter to BIP report
    Content:

    In fusion application, an ESS Job is defined as BIPJobType which calls a BIP report. We want to populate a parameter in BIP Report with the ESS process id. Is there a way to achieve this?

  • Sumanth Kunimakki sathyamurthy
    View future scheduled ESS jobs in SaaS4
    Topic posted July 18, 2019 by Sumanth Kunimakki sathyamurthy, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, Reports in Reporting and Analytics for ERP public
    Title:
    View future scheduled ESS jobs in SaaS
    Summary:
    We have a requirement to extract the future scheduled jobs for a user.
    Content:

    Test Case: Admin wants to know what are the future jobs scheduled for a user. In case if an employee leaves the company he wants to cancel the future jobs scheduled by that user. Customer is looking for an extract that will show these details.

    ESS_REQUEST_HISTORY table is not giving me the future scheduled jobs, it is giving me the details of already run jobs

  • Manideepa Talukdar
    BIP SAAS Reports5
    Topic posted July 17, 2019 by Manideepa Talukdar, tagged BI Publisher, Cloud Provisioning in Business Analytics > Business Intelligence public
    Title:
    BIP SAAS Reports
    Summary:
    BIP SAAS OOTB reports in Oracle Utilities
    Content:

    Hi,

    Can I get a list of out of the box BIP reports as part of Oracle Utilities CCS? Also the underlying architecture? That is the business logic needs ETL tools? What tools?

     

    Version:
    Latest
  • Syam Nakka
    How to see future jobs schedule in BI PublisherAnswered6
    Topic posted July 16, 2019 by Syam Nakka, tagged BI Publisher in Business Analytics > Business Intelligence public
    Title:
    How to see future jobs schedule in BI Publisher
    Summary:
    I am trying to see the future jobs schedule information for the BIP reports which have been scheduled
    Content:

    I am trying to see the future jobs schedule information for the BIP reports which have been scheduled. I am able too see only history jobs information only when I click job history. How to find this information.

    Please suggest

    Version:
    12.2.1.3.0
  • Farooq Haider Syed, PMP
    What is the use of all these data sources in BI
    Topic posted July 16, 2019 by Farooq Haider Syed, PMPGold Crown: 30,000+ Points, tagged BI Publisher in Engagement Cloud > Reporting and Analytics for Engagement Cloud public
    Title:
    What is the use of all these data sources in BI
    Summary:
    Use of data sources
    Content:

    Multiple data sources are showing in BI while creating the data model, what is the use for each one? why we have multiple.

    And which one is to be used for creating data model.

     

    Thanks

    Image:
  • Hari Thyagaraj
    Custom Groups in BIP
    Topic posted July 15, 2019 by Hari ThyagarajRed Ribbon: 250+ Points, tagged BI Publisher, Reports in Reporting and Analytics for ERP public
    Title:
    Custom Groups in BIP
    Summary:
    Need to create custom grouping of Accounts in BIP
    Content:

    Hello - I have a requirement to show selected account attribute values from Account dimension in an expense report. In OTBI I can use Selection steps or BINS to create custom groups/categories and add those dimensional values to that group. Can you let me know how this can be achieved in BIP? Trying to estimate the level of effort so that I can provide appropriate recommendation.

     

    Thanks.