Welcome to the Oracle Analytics Community

Products Banner

Dennis Hancy ✭✭✭✭

Comments

  • 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…
  • Here's a screen print showing the issue I am facing. Thanks, Dennis
  • A co-worker did some research on Oracle Support earlier. He found an article, Oracle Support Note 2272915.1. It describes the issue we are having. The article refers to a patch that can be applied: 25353706. It says that this fix is included in version 12.2.1.3.0. Like Rizwan, we are on version 12.2.1.2.0. We have not yet…
  • Thanks Rizwan and Robert. It's good to know that we're not the only ones experiencing this issue. I was starting to think we were just missing something obvious. I'm intrigued by the idea of using a formula to generate the URL. How would that work? Would I create a new column whose formula results in the entire URL? And…
  • Hello, After a month, I am finally getting back to this. Thought I'd add more information to see if that helps clarify the issue I am having. On the criteria tab, I navigate to the hierarchy column. I select Column Properties and click the Interaction Tab. Primary Action is: Drill + Action Link The URL is:…
  • Did you mean to say "Fact -> A -> B in the logical"? This could be just my ignorance showing again, but we don't have any fact tables in the physical layer. So far, we've only seen fact table at the logical layers. Anyway, if you did mean "logical", we did have (Fact -> A -> B) originally. However, as we continue our trial…
  • I'll try to answer this as best I can. Table "A" is a dimension table. Table "B" appears to be a dimension table as well (given there is no # symbol next to it), It contains additional information that we want to look up through the ID field. I am still wrestling with some of these basic concepts such as dimension and fact…
  • Hi. Thanks for your replies. By "clone", I simply meant that we have another table very similar to the one I am trying to create. Among other things, the new one contains a hierarchy similar to the one that already exists. It is not a copy in the "drag and drop" sense; it's more of a copy in the sense that I tried to…
  • Thanks, but that link is for a 2 hour course on building analyses and dashboards. I have some background in that already, but this is the first time I have encountered this particular problem. If I mark the parameters (in this case they are column values) as fixed and hidden, then they do not get passed to the second level…
  • Thanks! " RANK(ticket_number BY employee_id) = 1 " works perfectly. I appreciate the tip. Thanks everyone.
  • Thanks! I didn't even know that option was available. I gave that a try. But it looks like it's only printing the filters on the analysis. I think our users are hoping to print the dashboard prompts as well. My guess is that since our prompts are on the dashboard level, that printing the analysis by itself would not know…