Thank you for your reply. In the Oracle documentation, under the section labeled "What Are Conditions?", it says ----- * For an analysis, it evaluates the row count of the analysis. For example, a condition might evaluate whether the results of an analysis return a number of rows greater than 0: * If the analysis returns…

Thanks for your reply. Unfortunately, despite my efforts, we don't have access to Catalog Manager here. I guess I was curious though, as to why the Add/Remove Subject Area icon is grayed out in this case.

Thanks everyone for your suggestions on this. Because we were in a bit of a time crunch on this, we took the path of least resistance - at least for now. We ended up defining an alias in ActionFrameworkConfig.xml - one in Dev, one in Test, and one in Prod. The URL field in Action Links allow us to reference that value,…

Yes. We were hoping to have the entire URL as a parameter. Is that possible?

Hi. We have 12.2.1.4.0. We tried entering this as a parameter, but we received the following error message. The value of HELP_URL is something like https://www.google.com/ We also tried entering this: VALUEOF(NQ_SESSION.HELP_URL), but then it attempts to open this: http://valueof(nq_session.help_url)/ Thanks. Dennis

Just a quick follow-up on this... I ended up abandoning the View Selector approach. In its place, I added a variable dashboard prompt and assigned it to a presentation variable. Then, when the user drills down to the lower level pages, I included a column in my analysis whose formula is a "case" statement. If the value of…

Sorry.. that was a typo on my part. I meant to say View Selector.

Thanks. We've passed values between screen before - but it's always been values from various attributes. Does the value selected from a value selector also get passed automatically? If so, how do we refer to it on the target page and analysis?

We found the answer. We were using a column prompt which is only associated with one particular column. But we later learned that a variable prompt is more generic. It is not attached to just one column and can be used more freely.

Here are the screen shots of our set-up. Let me know if this help. Thanks! Version Number: Prompt: Filters in Analysis: Resulting "where" clause in SQL: WHERE ( (( "table"."COLUMN_1" ='turkey') OR ("table"."COLUMN_2" ='@{pv_1}')))