Dynamic Subset creation by connecting 2 dimension of cube

[ananthu007]

I m need the following functionality in a cube using dynamic subset creation by relating 2 dimensions of a cube. For example I have two dimesion called country and branches. if i select the any country in view of the cube then only branches of that country should be shown in branch dimension. for Linking these 2 dimensions,Branch dimension alread have text attributes as country values.

I try to create this using dynamic subset creation and the create subset not get effected in the cube.

Please any person known how to creation/configuratin of this dynmic subset.
Ananthanarayanan c

[ajain86]

I do not believe this capability exists as how would the subset know what you have selected from the other dimension.

Have you thought of possibly combining the 2 dimensions if they are so closely related to each other.

[jim wood]

You can build a view that is filtered to do something like this. Right click on the cube and select export to ascii. You'll find the filters in the top right hand corner. I'm not 100% certain if this would be the best fit but something to start with.

Other wise you might be looking at doing something through TI,

Jim.

[lotsaram]

I m need the following functionality in a cube using dynamic subset creation by relating 2 dimensions of a cube. For example I have two dimesion called country and branches. if i select the any country in view of the cube then only branches of that country should be shown in branch dimension. for Linking these 2 dimensions,Branch dimension alread have text attributes as country values.

I try to create this using dynamic subset creation and the create subset not get effected in the cube.

Please any person known how to creation/configuratin of this dynmic subset.
Ananthanarayanan c

If zero supression is on in the view then you should get this behaviour by default as only branches of the country selected will contain data ...

However if you want to get the same result for data entry then you are stuck as far as the cube viewer goes as I don't believe there is any way to pass the CurrentMember property of the Country dimension into an MDX statement of the Branch dimension. (Note to IBM listeners, it would be great if this was possible! This would be handy for contributor apps as currently achieving this sort of behaviour without pre-seeding with data and zero supression isn't possible without using element security instead which isn't always possible if access is required to other nodes.)

However, assuming you have an attribute against branch which identifies the country to which it belongs then you can do this very easily in an active form as in Excel (or a websheet) it is very easy to pass the context of the cell in which country is selected into an MDX statement that defines the Branch rowset and return only the relevant branches.