Hi,I'm assuming the report is built over a dimensional package? Can you be a bit more specific about what you are doing? You mention filtering, but is this via a dimensional filter function in an expression, or are you using detail filters? Would the set of members you want to see in Level 2 be static, or would they change over time?Cheers!
Hi,Using detail filters with a dimensional package something I always advise caution over. Detail filters are a relational reporting concept, and can often deliver results that are incorrect when used with a dimensional source.You mention originally that you are using a tree prompt? Usually you'd feed this with a set of members. It looks like you need the members at level 1 filtered based on a measure value? Do you have the same requirement for members at level 2 also?For filtering a set of members, rather than using a detail filter, I would suggest you use a dimensional expression for the set, egfilter([your set of members], [your measure] > 3)I'm still not clear on how you need your tree prompt to be populated, though. Can you provide more detail?Cheers!
Hi,I'm not sure what you are trying to do is possible with a tree prompt. You are always going to see all child members of any members you include in the prompt, so if you include members from level 1, you will see all of their children on level 2. I would suggest you use a value prompt instead, fed from the filtered set of members you need from level 2.Cheers!