cognos 8 report studio filter problem

[lwpg]

I need to filter a report by brand and delivery type. Corporate owns 2 restaurant chains A & B. I only need A, which I have working. Of the A's, I only want restaurants that are delivery restaurants included in the report.

This is the expression to get chain A:

[Delivery and Call Analysis cube].[Consolidated].[Consolidated].[Brand]->:[PC].[@MEMBER].[00002]

I thought I could just do a tuple for the desired results:

tuple([Delivery and Call Analysis cube].[Consolidated].[Consolidated].[Brand]->:[PC].[@MEMBER].[00002],[Delivery and Call Analysis cube].[Occasions].[Occasions].[Delivery Status]->:[PC].[@MEMBER].[Delivery])

But then I lose drill down entirely.

I thought I could just add a filter:

[Occasions]=[Delivery]

But that didn't work either.

Any ideas would be appreciated. Thank you.

 

[yphilogene]

Try the Status member in slicer area

 

[lwpg]

I tried member sets and lost drill down entirely. I tried a slicer and it didn't work.

I need to go from brand A to Regional VP to District Manager to restaurants. The restaurants that are not delivery should not show on the drill down. Ideally, the DMs that don't have delivery restaurants should not show on the drill down either. Everything's working except for the non-delivery restaurants show & shouldn't.

Brand and delivery are in 2 separate dimensions within the same package.

Any ideas would be helpful. Thank you.