Oracle Analytics Publisher

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
59
Views
5
Comments
Ngoc Phung
Ngoc Phung Rank 3 - Community Apprentice

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?

Regards,

Ngoc

Best Answer

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

    I used Download / Upload and your issue did not replicate.

    Rgds,

    Kevin

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 April 11

    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

    Regards,

    Ngoc

  • 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 April 14

    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

    Regards,

    Ngoc