Subset by Values in Other cube

[vinnusea]

Hi Guys,

Am trying to filter my period subset by values present in Other cube A. in Cube A there are 4 place holders for periods. I want to create a Dynamic subset to filter to only those 4 periods all time.
Ex; Cube intersections are
[Cube A] .([ DIM A].[Element A1], [DIM B].[Element B1])
[Cube A] .([ DIM A].[Element A1], [DIM B].[Element B2])
[Cube A] .([ DIM A].[Element A1], [DIM B].[Element B3])
[Cube A] .([ DIM A].[Element A1], [DIM B].[Element B4])

I am Able To:

Am able to filter my period subset for only one cell value so far but could not do for 4. Here is my code for filtering just 1 value

Code: Select all

{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Period] ) } , [CUBE A].([DIM A].[Element A1] , [DIM B].[Element B1] )  )}

Please help me to filter the period subset with all other 3 cube values.
Thanks in Advance.

[jim wood]

Did you try doing a search on this? If I remember rightly this has been discussed a few times.

[jim wood]

Try this for instance:

http://www.tm1forum.com/viewtopic.php?f=3&t=471

[vinnusea]

Yes sorry guys ... was only thinking to write MDX and filter...
Yes i got it its working.
Appreciated