Include Or Exclude Dimensions

[Anonymous]

Hi All,

     We have scenario to include or exclude specific dimension value. I have attached the QVW file along with the excel datasource..

There are 3 dimensions in the attached QVW file. Milk Bottle (Dimension-DIM2) is available under Baby Product (Dimension-DIM1) and also inside  Self Care (DIM2).

There is a button which will tell me whether to inlude Milk Bottle into the Baby Product or Self Care?. On this button click i need to inlucde Milk Bottle to Baby Product and exclude from Self Care?

Can you help me finding a solutions for this ie dynmically including or excluding dimension values?

Thanks

Dasu.G

[#2]

Can you explain more the user experiece you are seeking?

If the user selets Dim 1 = Baby Product, then by association the selection of Dim2 = Milk Bottle works as expected.

Likewise if the user drills down using your "Test Table" and the drill down group.

If the user instead starts with clear selections, and selects Dim2 = Milk Bottle, then they can either select a Dim 1 value, or a Dim3 value, but the association takes care of itself.  You could add a button that selects one or the other in Dim 1 if you want (where Action is 'Select in Field', Field is 'Dim 1', and value is Baby Product, for example).  But if you already have a list box with Dim 1 available, would it not be easier to just use that (and more clear to the user)?

Perhaps I misunderstand you?