How to create dynamic subset based on selected title element

[karuso_25]

How will I create Dynamic Subset to narrow list of elements based on selected Cube Title Element.

Sample:

Product Dim:
A
B
C
D

Store:
1
2
3
4

Cube 1: Product - Store Mapping
1 2 3
A Y N Y
B N Y N
C N N Y
D Y Y N
E Y Y Y


Sales Cube:
If I select Store 1, the subset of product should display A, D and E only.
If I select Store 2, the subset of product should display B, D and E only.

This should be on the cube viewer only.

{Admin Note: Moved from Bugs to the general TM1 forum following the highly apt quote of the week from Lotsaram.}

[lotsaram]

Not knowing how to do something does not make it a bug.

What you want to do is easily achievable in Excel or a websheet and can be done in only the cube viewer but can't be achieved within a single cube view (using 2 views it would be possible but then what would be the point?)

[karuso_25]

My bad. This is not a bug. I put it on a wrong forum.

But I already made this using this kind of filter.

{ FILTER( {TM1SUBSETALL( [DIM to Filter] )}, [Cube Mapping].([DIM as Filter].CurrentMember,[Cube Mapping Measure].[nTag]) > 0) }

That's it.

Thanks a lot!

[Roei]

Hi,

I'm having the same problem.
Can you please describe what is each of the variables?
You can use your own example.

Regards,
Roei

[karuso_25]

Hi,

I'm having the same problem.
Can you please describe what is each of the variables?
You can use your own example.

Regards,
Roei

I created a mapping cube (say Cube Mapping) where dimensions are Product, Store and a measure(say nTag).

{ FILTER( {TM1SUBSETALL( [DIM to Filter] )}, [Cube Mapping].([DIM as Filter].CurrentMember,[Cube Mapping Measure].[nTag]) > 0) }

DIM to Filter = Product
Cube Mapping = created mapping cube
DIM as Filter = Store
Cube Mapping Measure = measure dimension of created mapping cube

Save the subset in DIM to Filter.

In other cube containing Product and store, set product(with above subset) as row dimension and store as title dimension, this should be able to narrow the list based on store.

[mvaspal]

Hi

I have just created a similar dynamic subset. Does anyone know if we can make it work somehow so that both the Dim To Filter and the Dim as Filter are on title?
In the example above, if I select a store, I would like to see the list of products sold in that store, but both stores and products should be title dimensions.

Thanks
Matyas


UPDATE: it seems to be working in Performance Modeler (10.2) but not in Cube Viewer, TM1 Web, and Contributor (also 10.2).