Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
That was it, thank you very much!
-
Basically, if a user types AllAccts in the prompt, and say level 31 has AllAccts underneath it in the hierarchy, I'd want that AllAccts prompt to query against level 31 value, so I was thinking something like CASE WHEN value = Level 31 Value THEN Level 31 Value WHEN value = 30 value THEN 30 value Etc… Posted a picture…