Hi, Also, was this working before at any point? Yes, it was working before about couple of months ago and just added two new columns to the report but even if we run the old report, its the same issue. Basically, the moment you click on Export to CSV, we wont even get a bottom bar stating that its downloading which is…

Its a little complicated so I am already trying your first solution but not having much of luck. Here is what I am trying: '$'||CAST(Cast(IfNull("Measures YTD"."Giving Donor Count Fiscal YTD", 0) As Double) / Cast(IfNull("Measures YTD"."Solicited Donor Count Fiscal YTD",0) + IfNull("Measures YTD"."Solicited Staff Count…

How do you close the thread? I cant seem to find that...

Here is what it looks like:

Yup... I just didnt know that option and sadly it was hard to find anywhere on the net

Thank you and I am using 12.2.1.3

I was trying to get a page which can replace the OBIEE home page by manually activating some exception or a link or something... Your answer lets me think more over what and how I can layout the strategy

Well, I was thinking more on the Catlog side where as soon as we know the ETL failed, we can replace all Dashboards with a message unless there is some dbms jobs can be run to achieve this?

I think there is a solution but its your call if its really worth it... Create your prompts as RPD View, join that View to the existing Star Schema with a proper relational join, create all your prompts using that View so you can use "Limit Values" option

Good call!

lol... I wish that analogy resolves the issue but it doesnt... Offcourse, I didnt want to be in this situation either and wish it was otherwise but unfortunately it is what it is... But I do wonder why OBIEE application design have the "Limit Values By" option but not with SQL Block? This is purely lackluster OBIEE…

Just to clarify that it works fine when I remove the apply button but then everything within the Dashboard refreshes while you are updating any of the prompts

Thank you and here it is: Primary Plan prompt has SQL embedded in it as follows: I would like the above to limit data by the following prompt which has the variable "var_career_level" as shown below: Thanks in advance!

I was reading about Dashboard Filters and Variables and wondering if that can somehow play a role in this situation:

With the Apply button its fine but its doesnt limit the values from one prompt to the other... Is there any other way around this? Basically, I want the Dashboard Prompt with the embedded SQL to be limiting its values from the previous prompt.

I presented to the team but they dont like "Apply" button being removed because we have 8 prompts and they didnt like the Dashboard to be keep updating while changing prompts. Would I have any other options to go about this?

Couldnt agree more

Thanks a bunch and it works

Thanks but then how would Users run the Dashboard after applying all the promtps?