Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How do I preserve parameter visibility settings when migrating BI Publisher reports to a new server?

Accepted answer
53
Views
5
Comments
Ngoc Phung
Ngoc Phung Rank 3 - Community Apprentice
edited Apr 10, 2025 9:07PM in Oracle Analytics Publisher

I was working with Oracle BI Publisher and I came upon this problem:

In the Report Editor page, there's a Parameters dialog where you can choose to show or hide specific parameters in a report by checking or unchecking a boxes in the 'Show' column.

Let's say I check the first 2 parameters and uncheck the third, I call it the "original visibility setting" on a report. Now if I move my BI Publisher reports to a new server, all parameter checkboxes are automatically set to be checked, meaning all parameters will become visible - including ones I originally had unchecked.

My question is: How can I ensure that the original visibility settings for parameters on reports are preserved when migrating BI Publisher reports to a new server?

Tagged:

Best Answer

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Migrating reports and data models should not change the objects.

    I tested using Download / Upload and the show parameter settings were retained in the copy.

    How are you migrating data models and reports?

    Rgds,

    Kevin

  • Ngoc Phung
    Ngoc Phung Rank 3 - Community Apprentice
    edited Apr 11, 2025 7:49AM
    https://community.oracle.com/products/oracleanalytics/discussion/comment/66248#Comment_66248

    Sorry, I forgot to add: when I said "move my BI Publisher reports to a new server", I meant to move the reports from Oracle BI Publisher 11g to a new server in OAS. I've tried to import the report's zip file and upload it directly into OAS but the original visibility setting is all reset for some reason

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    How did you generate the reports zip file in 11g?

    How did you import the zip file to OAS?

    Rgds,

    Kevin

  • Ngoc Phung
    Ngoc Phung Rank 3 - Community Apprentice
    edited Apr 14, 2025 10:32AM

    I exported them manually from BI Publisher and got .xdoz files, I made sure to even check the zip file right after that and the visibility was set as I expected

    Then I imported some of them as a test to OAS and when I checked, all the parameters visibility was set to 'true'. I'm not sure how did this happen