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 Lockdown25.0
    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.
  • Madhu Babu Vitta
    Timezone - BIP Report schedule default
    Topic posted Yesterday by Madhu Babu VittaBlue Ribbon: 750+ Points, tagged BI Publisher, Fusion Financial reporting in Reporting and Analytics for ERP public
    Title:
    Timezone - BIP Report schedule default
    Summary:
    Timezone - BIP Report schedule default
    Content:

    Hello All,

    When we schedule any BIP report, in Output tab we noticed that below is the default timezone for all users.

    (UTC-11:00) Midway - Samoa Time (ST)

    We would like to have UTC/GMT as the default timezone for all the users when running report by scheduling or online/adhoc.

    We tried the below setup but it is not updating the timezone in the Output tab.

    1) My Account

    Tabs - Preferences , BI Publisher preferences

    It is GMT

    2) Administration->Runtime Configuration->Properties

    FO Processing-> Report Timezone

    Changed it to User

    3) In UI , Username -> Set Preferences -> General Preferences -> Regional

    It is UTC

    Let me know if you have any solution/workaround.

    Thanks,

    Madhu

    Document:
    Timezone.PNG (733KB)
    Document:
    Document:
    Document:
  • Brian Hall
    Maintain integrity in DIM/FACT WIDs1
    Topic posted Yesterday by Brian HallBronze Medal: 1,250+ Points, tagged BI Publisher, Business Intelligence, Data Sync in Business Analytics > Business Intelligence public
    Title:
    Maintain integrity in DIM/FACT WIDs
    Summary:
    Looking for the best way to maintain links/joins from DIM & FACT tables
    Content:

    All DIM tables have a Warehouse ID number (WID).  Joins are added to the Target FACT tables to link said DIM table in Data-Sync.  When/If changes (Add/Drop) columns or refreshing data back to initial load status are done.  This resets these WIDs.  This in-turn breaks the links within the report designer and can cause the lose of the visualizer report.

    How can we keep this from happening?

    Version:
    Oracle Analytics Cloud Data Sync (2.6) / OAAC
  • Ansuman Mohapatra
    OTBI Requirement14.0
    Topic posted May 20, 2019 by Ansuman MohapatraGreen Ribbon: 100+ Points, tagged BI Publisher, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Requirement
    Summary:
    Setting a Flag By Updating Attribute Column in Invoice Header Table
    Content:

    Hi,

    We designed a report which send notification for cancelled invoices to vendors showing the cancellation reason of the invoice and re-issues new invoices. 

    We  have a parameter for the report where user choose for which invoice they need to send and the parameter LOV shows all cancelled invoices.

    I would like know is there a way we can set a flag for each invoice for which the report is already ran, so that we can use the flag condition to filter out the invoice from the parameter list.

    We are in Cloud Financial SaaS.

    I tried to research, if any means any service can be called post report run to update the one of the attribute column of invoice header to set the flag but no luck.

    Is anyone achieved similar requirement? 

    Thanks

    Ansuman

    Version:
    Oracle Cloud Financials 19A
  • Vijaykumar Yes
    Essbase Server Logs1
    Topic posted May 20, 2019 by Vijaykumar YesBronze Medal: 1,250+ Points, tagged BI Publisher, OAC Enterprise Edition in Business Analytics > Business Intelligence public
    Title:
    Essbase Server Logs
    Summary:
    Essbase Server Logs
    Content:
     Hello All, We have an issue with Essbase services, tried to start services multiple times but it did not start finally we noticed that database is down and informed database team to fix the issue from their end, but DB team is asking to show some evidence that Essbase services are down because of DB down (I known it sounds wired) they want some log files as evidence So, what will be the location of log files to shoe DB is down.. I checked Essbase.log and Essbase.odl files I did not find any thing Environment : Windows 64-bit Essbase Ver :11.1.2.4 Thanks in Advance VJ
    Version:
    11.1.2.4
  • Vidya Sagar Mahankali
    Unable to Create report using Template Builder for WordAnswered4
    Topic posted May 18, 2019 by Vidya Sagar MahankaliGreen Ribbon: 100+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    Unable to Create report using Template Builder for Word
    Summary:
    Unable to Create report template using sample xml from BI publisher 12.2.5.0
    Content:

    Hi,

    I have successfully created a data model using the web service of OIC in BI Publisher. I am following this article for creating the data model in BI Publisher.

    I am using the sample.xml generated in Data Model to generate an RTF template in word. It is generating a blank page as a sample output even after placing all fields onto the page.

    The RTF template and sample XML file are attached to this post.


    Thanks

    Version:
    12.2.1.4.0
    Code Snippet:
    Document:
    Document:
  • Srekan
    BI publisher 12c Issue: space between some of the words has...
    Topic posted May 17, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher in Business Analytics > Business Intelligence public
    Title:
    BI publisher 12c Issue: space between some of the words has been removed and the words are conjoined
    Summary:
    space between some of the words has been removed and the words are conjoined
    Content:

    Hi All,

    in BI publisher 12c RTF template contains some paragraphs data, when we look the result in PDF format there are some issues in paragraph. The issue is space between some of the words has been removed and the words are conjoined.

    whereas in 11g looks good. Any properties need to setup in 12c? please let me know.

     

    Thanks,

    Jag

  • Brian Burns
    OTBI Analysis: Is it possible to add a column that...Answered25.0
    Topic posted May 15, 2019 by Brian BurnsGold Crown: 30,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?
    Summary:
    I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columns
    Content:

    I'm building an OTBI Analysis using Payables Invoices - Transactions Real Time and I wanted to know if it's possible to create a calculated column that summarizes the invoice column to show total spend by that vendor for the period of the report.

    For example, I have 3 columns:

    Supplier          Invoice Number       Invoice Amount

     

    I want to have 4 columns

    Supplier         Invoice Number        Invoice Amount        Total Spend by Supplier

     

    There are some summary functions in OTBI but so far they just sum up the total but not by Suppler. I don't seem to be able to "Group By" or get anything to work in the calculated field to do this.

     

    Thank you,

    Brian