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.
  • 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.
  • Lydibel Murillo
    SQL Table to bring in Audited by from the AP module to a BI...2
    Topic posted 9:34 AM by Lydibel Murillo, tagged BI Publisher in Reporting and Analytics for ERP public
    Title:
    SQL Table to bring in Audited by from the AP module to a BI report
    Summary:
    SQL Table to bring in Audited by from the AP module to a BI report
    Content:

    I am searching for the SQL table to bring in Audited by from the AP module to a BI report.

  • Jennifer Wolfe
    Expenses Overview Real Time subject area1
    Topic posted October 16, 2019 by Jennifer WolfeRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Expenses Overview Real Time subject area
    Summary:
    A summarization program needs to be run to gather information before data is available in this area.
    Content:

    We are creating some test reports from the Expenses Overview Real Time subject area.  There is basically no data there and I expected to see some as I know multiple claims have been entered in the system.

    In doing some research on this, I found this in Oracle's documentation:

    This subject area enables summarized, metric-based reporting. Use this subject area to analyze expenses across cost centers, compare current and previous period expenses, identify top spenders and cost centers, and spend by merchants  A summarization program needs to be run to gather information before data is available in this area.

    Can you help me to identify what this process might be?

    Thanks in advance,

    Jennifer

  • Geetha Devi
    how to connect to Bi publisher administer console in fusion...Answered103.0
    Topic posted October 15, 2019 by Geetha DeviRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, OBIEE Answers in General OBIEE public
    Title:
    how to connect to Bi publisher administer console in fusion 19C?
    Summary:
    How to access the bi publisher administer console in fusion 19c?
    Content:

    I  have added some roles to my fusion account. But, I cannot see the bi publisher administrator console offering in fusion 19c

    Could anyone please help with this?

     

     

  • Hari Thyagaraj
    Inventory Reconciliation with GL - Report
    Topic posted October 14, 2019 by Hari ThyagarajRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Supply Chain Management reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Inventory Reconciliation with GL - Report
    Content:

    All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requirement? Is that the only solution in Oracle? Can we create a custom OTBI analysis for this using the Subledger SA? Can you throw some light on this? 

  • Lak
    Oracle BIP Report RTF Template - Distribution Accounting...4
    Topic posted October 14, 2019 by LakGreen Ribbon: 100+ Points, tagged BI Publisher, Reports in Reporting and Analytics for ERP public
    Title:
    Oracle BIP Report RTF Template - Distribution Accounting Date Display
    Summary:
    Oracle BIP Report RTF Template - Distribution Accounting Date Display
    Content:

    Hi All,

    Hope you are doing well. Could you please suggest me on below rtf template related question?

    We want to print distribution account date in report, where xml has value and rtf does not have tag.
    Please see attached xml, we have distribution accounting date in INV_DIST Group-ACCOUNTING_DATE Column. In rtf, we want to print distribution accounting date in INV_DIST_DS_V2 group along with INVD_CONCATENATED_SEGMENTS column.

    From INV_DIST_DS_V2 how to print INV_DIST->ACCOUNTING_DATE date column. I have tried multiple ways it’s not working as I expected. Please suggest.

    Note: In the rtf no where we have used INV_DIST group till now.

     

    Thanks in advance for your help.

    Version:
    Oracle Cloud SaaS R13
    Image:
  • Srekan
    Date with timestamp parameter in BI publisher report 12c
    Topic posted October 11, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    Date with timestamp parameter in BI publisher report 12c
    Summary:
    datetime parameters passing in BI publisher report
    Content:

    Hi All,

    i am creating datewithtime parameterized report.

    i have database time column(xx_time) and the data as in the format of  10-OCT-19 09.45.22.846000000 AM  -------------> it is in (CST) format. But i have to show in EST format. For that i have used CAST(FROM_TZ(CAST(xx_ba.xx_time AS TIMESTAMP), 'CST') at TIME zone 'America/New_York' AS DATE) AS TIMEST. its working here.

    now i have to fetch records on TIMEST (which is calcualted column)  between start date and enddate parameters. whereas parameters datetime format as 10/13/2019 10:30:15 AM (MM/dd/yyyy hh:mi:ss AM).

    i have used query as

    SELECT xx_id,
        xx_time,
        TIMEST
        
      FROM
        (SELECT xx_ba.xx_id,
          xx_ba.xx_time,
      CAST(FROM_TZ(CAST(xx_ba.xx_time AS TIMESTAMP), 'CST') at TIME zone 'America/New_York' AS DATE) AS TIMEST
          
        FROM xx_ba xx_ba
        )
      WHERE TIMEST >= to_date(to_char(:startDate, 'MM/dd/yyyy hh:mi:ss AM'),'MM/dd/yyyy hh:mi:ss AM')
      AND TIMEST <= to_date(to_char(:endDate, 'MM/dd/yyyy hh:mi:ss AM'), 'MM/dd/yyyy hh:mi:ss AM')

    throwing error

    ORA-01722: invalid number
    01722. 00000 -  "invalid number"
    *Cause:    
    *Action:

     

    tried different options but no luck, Any help on this really appreciated.

    Regards,

    Joes

  • GIUSEPPE IACONO
    Oracle Business Intelligence 11g installation65.0
    Topic posted October 11, 2019 by GIUSEPPE IACONOSilver Medal: 2,000+ Points, tagged BI Publisher in General OBIEE public
    Title:
    Oracle Business Intelligence 11g installation
    Content:

    I Guys,

    I want to install Oracle Business Intelligence 11g, I Just download the 5 file.zip from https://www.oracle.com/middleware/technologies/bi-downloads.html

    I unziped the files in a folder and executed: C:\Users\Desktop\bishiphome\Disk1\install\win64\setup.exe.

    I arrived to the steps 8, but now I don't know where I can find the value of the field to continue.

    Can Someone helps me?

    Best Regards

    Giuseppe

    Image: