The other problem is if I use your example to implement in my analysis, the measure column will show a total as below: It shows only the highest hierarchy level with a total measure. But what I expected is more like As you can see, the hierarchy remains. So, the "All values" in the Discoverer is more like "does not pick…

Thanks to Christian and Gianni. I am sorry for that I misleading you both. Yes, prompts do not filter data. Actually, what I faced now is migrating reports from Discoverer to OBIEE. And I found a report in Discoverer, its prompts are more like pivot table prompts in the "Prompt" Section. At beginning, those prompts are…

Hi Christian: What I taking about is just like the pic shown as below: and I wish to the default option is 'All values', not '131110013'. Thank you, Sting Wu

Hi Christian: I am talking about the pivot table prompt. The prompt you mentioned will disappear after user picked a value. The pivot table prompt will act like a filter and it can be drag to table or drag to be a prompt in an analysis. Thank you, Sting wu