Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
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