Hi Gurus,
I am facing a problem in my report. That report picks up from a Native Query subject. My report has two prompts, Region and Branch. I am cascading the Branch prompt which reference to Region prompt. The problem is, when I am imposing a filter like [Regions] = ?Region? to my report list, then cascading is not working. All branches are populating to Branch Prompt inspite of Region selected.
Note: To populate Region and Branch prompt I am using different query and its taking data from dimension table.
Please help me..
Thanks.
Have you checked that the prompt properties of both the Regions and Branch are set correctly? e.g. cascading source, auto-submit etc.
Have you looked into my tutorial on Cascading prompts?