Oracle Communities

Oracle Analytics and AI

Child Item

Analysis should be blank without prompt values

Hi All

I have a requirement to show blank analysis until someone select the values from prompt, my analysis is working fine when I select some values from prompt but at start when I open my dashboard, analysis show all the data (Fig.1).

However when I select some prompt value then it filter as per prompt value (Fig.2).

Fig.1, all data without prompt values

Fig.2, data as per Department values

please help

Find more posts tagged with

Accepted answers

All comments

Robert Angel

Hi,

if you set a presentation variable with your department prompt then you can use it as the value for your filter and have the presentation variable default to a value which will yield no results.

@{PV_Department}{NoValuesWantedHere}

Gianni Ceresa

The power of the documentation: https://docs.oracle.com/middleware/1221/biee/BIEUG/dashboards.htm#BIEUG13803

"Prompt before opening" which has been added in 12c (if not wrong) is there for that reason.

There are also conditions which can be used to hide the analysis etc.

Everything is either in the doc or well referenced in Google ....

Rai Qaiser Hussain

Hi @Robert Angel

I never used Presentation variable before, i have tried, please guide where I am wrong

Steps how I tried

From Month

To Month

First Tried this way, it generated error then searched at google and selected presentation

Presentation variable

Error Occured -- please guide which step I missed

Rai Qaiser Hussain

Hi @Gianni Ceresa

I have already read the shared document and read today (but not thouroughly today), If I am not wrong there is nothing about my problem.

However I have resolved my problem with following, needs your expert opinion either it is good approach or not.

Now data does not show until selection of some value from prompt

regards

Robert Angel

I had forgotten all about prompt before opening - nice catch!

Gianni Ceresa

Rai Qaiser Hussain wrote:If I am not wrong there is nothing about my problem.

You maybe want to read once again.

"Prompt before Opening" is the answer out of the box with a checkbox to what you ask, you maybe want to read once again the part about "Delaying the Execution of Dashboard Pages"...

Robert Angel

Gianni's suggestion is better, as it saves unnecessary processing time.

But, yes, you cannot use presentation variable with between, you would have to break it down into From / To PVs to make it work.

Rai Qaiser Hussain

Hi @Gianni Ceresa

I will

I shall be greatful if you please comment on presentation variable (Images attached in this thread), what I am missing?

I want to use between clause (from month and to month)

Month format is 'YYYY / MM' values (2019 / 02)

Rai Qaiser Hussain

Fig.1, break into two

Fig.2, analysis is working fine

Fig.3, Error when open that analysis on dashboard

Rai Qaiser Hussain

Hi @Gianni Ceresa

I think you were asking about this feature, Am I right? If I am right, actually my requirement was slightly different that's why I didn't used this feature and achieved with filter value.

Prompt before open.jpg