3153063 — Oracle Analytics

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

3153063 Rank 2 - Community Beginner

Comments

  • Chris, Excellent. Thank you! Interestingly, I found that I only have to do the Selected step the first time. Afterwards, I can enter a list as normal. I am guessing it's session-based and possibly intializes the variable in some way. Ron
  • Chris, Technically, the Choice List would work. However, if I had a list of say, 100 numbers, it would tedious to add them in one at a time. Any idea why it works at the analysis level, but not in the panel? Thanks, Ron
  • The physical query? Do you mean the SQL? "INCIDENT DETAIL DIMENSION"."INCIDENT_NO" IN ('Numbers')
  • Okay, I figured out how to do it. I created the column: COUNT("TIME_TYPE" BY "RECORD_NUM") and then filtered on more than 1 hit. Thanks to Gerardnico for explaining the BY clause. OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause [Gerardnico] Ron
  • Daniel, Thanks for the reply. I prefer not to key off the time elements. However, (along the same line of thinking I hope) is there a way to determine how many times the record number (111,222,333) appears and then filter out if less than 2? Thanks, Ron
  • Christian, Thank you for the quick reply. Unfortunately, it is in 2 different rows. (There's more info in each record, but I was simplifying it for the question). Yes, the Suppress is working. I just would like it smarter. :-) Thanks! Ron