Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Based on prompt selection display the reports

Received Response
77
Views
10
Comments
3586388
3586388 Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

Hi There,

I have three prompts A, B, C and  3 reports(Report 1, Report 2,Report 3). Based on prompt selection i want to see the individual report at a time by using section condition.

Condition is:

when i select the Prompt A value then i want to see Report 1 only.(B and C prompts defaults to All Column values)

when i select the Prompt A &B then i want to see Report 2 Only. (C prompt defaults to All Column values)

when i select the Prompt A & B & C then i want to see Report 3 Only.

I have created 3 analysis for 3 different sections.

In 1st Analysis , A is prompted.

In 2nd Analysis, A and B is prompted.

In 3rd section, A and B and C is prompted.

When i select Prompt A and B then am able see Report 1 and Report 2 in my dashboard, but actually need to show only report 2.

Please suggest me.

Thanks in Advance!

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    And what's the question?

    Because it looks a bit like "do my work for me" right now ...

    You have the logic, you have the concepts (conditions to show or hide sections of a page).

    So what did you try? What is working? What isn't working?

  • 3586388
    3586388 Rank 3 - Community Apprentice

    Hi Gianni, Thanks for reply.

    Am facing the problem like when i choose Prompt A and B then report 1 and report 2 are displaying in dashboard, but only report 2 need to display.

    Prompts Selected: A and B

    I have taken section conditions:

    For section 1 --> In analysis i have taken A is prompted and in section condition row count>0

    For section 2 --> In analysis i have taken A & B is Prompted and in section condition row count >0

    In dashboard am able to both reports 1, 2 but actually need to display report 2 only. 

    Please suggest what filters need to take in different analysis for the section conditions.

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    How does your "condition 1" looks like in OBIEE? You probably forgot to add to that condition that you want Prompt A to have a value selected, but you also want Prompt B and C without any value selected.

    So you have to "extend" your "condition 1" by adding the part checking for Prompt B and C.

  • 3586388
    3586388 Rank 3 - Community Apprentice

    How does your "condition 1" looks like in OBIEE?

    I have created  analysis with one column A and added filter  A is Prompted. Am using this analysis in section condition where row count>0.

    pastedImage_3.png

    pastedImage_7.png

    So you have to "extend" your "condition 1" by adding the part checking for Prompt B and C.

           Please suggest how to extend B and C to condition 1.

    I have tried filter for condition 1 like below,  but i didn't get.

    A is prompted

    AND @{B} = '(All Column Values)'

    AND @{C} = '(All Column Values)'

    Please correct me.

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    There is (was?) a value to use to match the "all column values", but I just can't remember it ...

    @Christian Berg, @Joel Acha I'm sure one of your 2 has it in mind

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You mean *)nqgtac(* ?

  • 3586388
    3586388 Rank 3 - Community Apprentice

    Hi Gianni, Chriian Thanks for the reply.

    My problem is resolved.

    I have used single space(' ') for the All column values in report criteria.

    When we choose the All column values or select values then presentation variable captures the single space (' ').

    conditions :

    For 1st Analysis

    pastedImage_4.png

    2nd Analysis

    pastedImage_5.png 

    3rd Analysis:

    pastedImage_6.png

    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    ALL your filter criteria are waiting for variables........are you sure you're using the tool as it is intended??

  • 3586388
    3586388 Rank 3 - Community Apprentice

    Yes Christian ,

       All filters are wait for variable and based on variable pass to the filters the report(Analysis) will give data.

    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    My point is: if you are doing that then it might be worth questioning if the tool is being used correctly.