Subset by Values in Other cube

yseen

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: {TM1FILTERBYPATTERN( {TM1SUBSETALL( &#91eriod] ) } , [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.

cttjs

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

mmkjzz

Try this for instance:

krc

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