nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Based on prompt selection display the reports

3586388

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!

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

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

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

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

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.

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

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]

You mean *)nqgtac(* ?

3586388

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

2nd Analysis

3rd Analysis:

Thanks

[Deleted User]

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

3586388

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]

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

Upcoming Event

Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Implementation Patterns, Security, and Best Practices
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…