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 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 Sales > Reporting and Analytics for Sales 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.
  • Stephanie Gott
    Expected Close date as Quarter and Year1
    Topic posted Yesterday by Stephanie GottSilver Medal: 2,000+ Points, tagged Dashboard, Data Visualization, Reporting and Analytics in Sales > Reporting and Analytics for Sales public
    Title:
    Expected Close date as Quarter and Year
    Summary:
    How can I show the Expected Close Date as a Quarter and Year?
    Content:

    Hello,

    Our Opportunities have an expected close date. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how to do this? I've tried using the Calendar functions in the formula. They work, but don't get me the exact above format. I have to use two separate columns. One gets the quarter number so, in the example above, it would just say "1". The other column I'm able to get the year "2020". When I try do a Concat in the 3rd column, I get syntax error b/c I think it doesn't like to concatenate formulas apparently. Any help would be appreciated. 

    Thanks,

    Stephanie

    Version:
    11.1.1.9.0
  • Cyrille Saulnier
    Display Link as a Button
    Topic posted November 7, 2019 by Cyrille SaulnierGreen Ribbon: 100+ Points, tagged Dashboard, Infolets, Reporting and Analytics, Tip in Sales > Reporting and Analytics for Sales public
    Title:
    Display Link as a Button
    Summary:
    Link is looking different in OBI and Sales Cloud
    Content:

    Hi

    I have built a link in a dashboard using SectionButton as a custom CSS. It displays well when I test the dashboard in OBI but the formatting is lost in Sales Cloud when the dashboard is accessed from an infolet or in the analytics section.

    Any idea?

     

    Image:
    Document:
  • Maleena De Zilva
    Table or Subject area to obtain information on defined PO/PR...
    Topic posted November 7, 2019 by Maleena De ZilvaRed Ribbon: 250+ Points, tagged Procurement, Reporting and Analytics in Reporting and Analytics for SCM public
    Title:
    Table or Subject area to obtain information on defined PO/PR approvals
    Summary:
    We require a report that provides information on the defined PO/PR approval rules and conditions
  • Pankaj Mongia
    Oracle Business Analytics Reporting Overview
    Topic posted November 6, 2019 by Pankaj Mongia, tagged Dashboards, OTBI, Reporting and Analytics, SCM in Reporting and Analytics for SCM public
    Title:
    Oracle Business Analytics Reporting Overview
    Summary:
    Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.
    Content:

    Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG4&feature=youtu.be

    This learning module provides an overview of Business Analytics Reporting. Watch this video to learn about the strategy and product coverage of Oracle Business Analytics as well its components and key features. In addition, you learn how to locate standard reports and dashboards as well as create and edit reports, analyses, and dashboards.

     

     

    Image:
    Code Snippet:
  • Adam
    My Team's Pipeline report not showing $ amount4
    Topic posted October 25, 2019 by AdamSilver Medal: 2,000+ Points, tagged Reporting and Analytics in Sales > Sales public
    Title:
    My Team's Pipeline report not showing $ amount
    Summary:
    My Team's Pipeline report not showing $ amount
    Content:

    I am executing an OOTB report "My Team's Pipeline". It is showing all the resources correctly but revenue $ amount is coming up as empty. I verified and user has the Sales Manager security role as well as correct resource role in 'Manager User's screen along with a valid organization. Other users are working fine. Only issue is with one user. PF screenshot that how I am seeing the report with this user.

     

    Version:
    19C
    Image:
  • Mary Beth Raven
    Oracle wants to interview you about making it easy to...
    Topic posted October 22, 2019 by Mary Beth RavenBlue Ribbon: 750+ Points, tagged Configuration, Customer Data Mgmt, Import/Export, Integration, Reporting and Analytics, UX in Sales > Sales public
    Title:
    Oracle wants to interview you about making it easy to integrate all sorts of apps. Receive Oracle merchandise for participating!
    Summary:
    Oracle wants to interview you about making it easy to integrate all sorts of apps. Receive Oracle merchandise for participating!
    Content:

    We’re looking for people to interview to get ideas for how we can radically simplify integrations.

    • Do you work in an IT Department developing applications for your company to use?
    • Do you administer or configure Cloud applications like Sales Cloud, ERP or SCM?
    • Have you configures any add-ones or plugins to cloud apps?
    • Maybe you’re a Salesforce or a NetSuite admin?
    • Have you worked on integrating any cloud apps with either other cloud apps or on-prem software? Maybe created a Slack integration?

    If you answered Yes to any of the above, we’d like to interview you (probably remotely via web conference) for about an hour. You will receive Oracle branded merchandise as a thank-you.

     

    P.S. We are looking for customers and partners rather than Oracle employees.

    If you are interested in participating, please contact Mary.beth.raven@oracle.com and she’ll set up a day and time with you.

  • Koteswararao Yenikepalli
    Need EL Expression for the Requisition ID from the...
    Topic posted October 10, 2019 by Koteswararao YenikepalliSilver Medal: 2,000+ Points, tagged Asset Tracking, BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Dashboards, Installed Base, Maintenance, Procurement, Reporting and Analytics, Sample Reports, SCM, Setup/Administration, SQL, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning, Tip, Upgrades, White Paper in Reporting and Analytics for SCM public
    Title:
    Need EL Expression for the Requisition ID from the Purchasing Screen
    Summary:
    Need EL Expression for the Requisition ID from the Purchasing Screen
    Content:

    Need EL Expression for the Requisition ID from the Purchasing Screen

    Version:
    19c
  • Koteswararao Yenikepalli
    How to update the value set values dynamically on the daily...
    Topic posted October 4, 2019 by Koteswararao YenikepalliSilver Medal: 2,000+ Points, tagged BI Cloud Connector, BI Publisher, BI Publisher Reports, Business Intelligence, Report Scheduling, Reporting and Analytics, Sample Reports, Setup/Administration, SQL, Tip, Upgrades, White Paper in Reporting and Analytics for SCM public
    Title:
    How to update the value set values dynamically on the daily basis
    Summary:
    How to update the value set values dynamically on the daily basis
    Content:

    Hello,

     

    We have a requirement like we have created the value set and we are trying to update the values by using HDL but the values need to update on a daily basis.

     

    Is there any way to update the value sets daily basis please suggest 

     

    Thank You.

    Version:
    19 C