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}')))

Thank you Jerry! This is awesome. It worked perfectly. You've saved me a lot of time trying to research this Dennis

Hi Jerry, The only way pv_FileName can be null is if the user does not select any value for the prompt (which seems to be the same as a "select all" option). I did try your suggestion of concatenating the two, but it also gave me the same error. Dennis

Thanks Jerry, for your reply. I did have one aggregate column in the exclude area. I moved it to columns and measures when I saw your reply, and marked it as hidden instead. Unfortunately I am still getting the same error. It seems that any function I apply to the stand-alone ReportTable"."File Name" column results in the…

As a follow-up to this conversation, I wanted to let you know that we ended up combining both of your suggestions into this one: ifnull(EVALUATE('TO_CHAR(%1,%2)' as char,DATECOL,'fmmm/dd/yyyy'),' ') We did have one further complication in that this field contains an action link. Since the screen it linked to was expecting…

Thanks Jerry, This is actually our second go-around with these pie charts. The first time, they noted that negative numbers were not being represented on the chart. We explained that pie charts don't do negative numbers, so they decided we could report on the ABS instead. Now they are asking us to change that baked-in…

Thank you!! My co-worker and I have been looking at this for the past hour or so when we saw your reply. His words: This is the best answer ever! It works like a champ. Thanks again. Dennis

Here is a screen print to demonstrate the issue. The lines with payment dates of 3/15/2019 and 4/1/2019 correctly print the subtotals as well as the "Total" label. But the line without a payment date value does not print the "Total" label. It only shows the subtotal values. Any assistance you can provide is greatly…

Thanks Jerry, The customer has decided to put this particular issue on hold. However, I am encouraged by your solution. I did not realize you could separate various views into different sections on the dashboard pages. Looking forward to trying this as it now sounds like they want to revisit this issue in the future.…

Just an FYI for anyone who is following this discussion... We were able track down the source of this issue. The issue is that one of our prompt values is *)nqgtn(*. From what we've read online, this has something to do with NULL values and presentation variables. The particular column is defined as a prompted filter in…

My co-worker and I were just looking at this. He found the answer. The "missing" folder is actually a child folder of another. Here are the steps we used to find it. Within the Presentation Layer of the RPD... 1. Right click on the parent folder. 2. Select Properties. 3. Click on the "Child Presentation Tables" tab. 4. The…