Toggle between analysis on Obiee Dashboard on BICS — Oracle Analytics

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

Toggle between analysis on Obiee Dashboard on BICS

Received Response
12
Views
4
Comments
user13483708
user13483708 Rank 2 - Community Beginner
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hi ,

We have hit a problem in OBIEE on BICS where in on the Section properties of Dashboard we don't get the "Condition" option to enable us to toggle the analysis based on condition.

We have two analysis and have to display each analysis based on some condition. Is there any other way of achiving this without the Section ->condition option??

Thanks in Advance

Raj

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Could you operate a workaround using the view selector functionality in answers, or are the two reports from disparate data sets?

    Alternatively you could put action links and have two versions of the same page, with the links navigating you from page to page, except for the report you want to display conditionally.

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    I think I have seen this issue before. Can you try something and let us know if this works. On the condition analysis disable cache. put SET VARIABLE DISABLE_CACHE_HIT = 1; in the prefix section of condition analysis. 

    Thanks

    Arijit

  • user13483708
    user13483708 Rank 2 - Community Beginner

    We have to call both analysis on the same page.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    So does my view selector suggestion work for you?

    And did you try @ArijitC suggestion re: disable_cache_hit which may solve your underlying issue?