Oracle Analytics Cloud and Server

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

Categories

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

Parameters in BI Catalog Reports reset its data

Received Response
102
Views
5
Comments
Cristian Betancur
Cristian Betancur Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

Parameters in BI Catalog Reports reset its data

Content

Hi

I have a report in Oracle BI Catalog with some parameters, some parameters are hidden and other parameters are selected.

When I select a parameter, it refresh other. However when refresh is finished, the actual parameter is reset.

This is image with steps:

I select Ledger Name ("Libro Contable"), with this parameter, Legal Entity ("Entidad Legal") and Ledger Currency ("Moneda Contable") automatically are updated.

image

But if I select  Period Type ("Tipo de período") (It has enabled "Refresh other parameters when It changes" option), these parameters are reseted (Some hidden parameters are reseted too)

image

image

Thanks

Cristian

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    post question in OBIEE forum

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Its in the right place. That is a pure BIP report with parameters on the side rather than on the top.

    I have a few questions:

    1.  Just checking but that looks like the 12c version of BIP, correct? Waht the full version you are using.

    2. Are the parameters that reset themselves based on list of value selection or are they user entered values?

    Tim

  • Gianni Ceresa
    Gianni Ceresa Mod

    Isn't it a BI Publisher report with parameters defined? In that case OBIEE has nothing to do and it's a 100% BI Publisher question, so it is in the right place.

    ​ : Can you confirm it is a 100% BI Publisher report with parameters there inside? And not an OBIEE dashboard sending parameters to Publisher?

  • Cristian Betancur
    Cristian Betancur Rank 2 - Community Beginner

    Hi

    1. We are in Oracle Fusion Applications R12, with Oracle Business Intelligence 11.1.1.9.0 (Build 170822.2343 64-bit)

    2. These parameters are obtained by LOV, and there are dependent parameters. I created Paerio Type parameter when "Refresh other parameters" option, because there is a dependent parameter; but when I selected the Period Type 

    parameter, other parameters reset (These parameters are not dependent of it).

    3. It is a 100% BI Publisher report, It is not an analysis.

    Thanks.

    Cristian.

  • Cristian Betancur
    Cristian Betancur Rank 2 - Community Beginner

    Hi

    A partner said me about Parameter Row Placement:

    image

    I use the same row placement in three parameters, and I change it in the next three.

    When I executed reporf:

    image

    image

    image

    image

    Parameters don't already reset:

    image

    Thanks for your feedback.

    Cristian.