TM1 Forum

Hi,
Help to deal with operation of expression of 'CurrentMember'.

I have 2 cubes - Cube_A and Cube_B:

Cube_A:
Period,
Accounts,
Dim_A1

Cube_B:
Period,
Company,
Dim_B1,
Dim_B2

Need create dynamic Subset in dimension Account which will be used as Picklist in Cube_B in dimension Dim_B1. I try to create it by means of the following request:
{ FILTER ({ TM1SubsetAll ([Accounts]) }, [Cube_A]. ([Dim_A1]. [Element_1], .CurrentMember [Period]) = 'True') }
but I do not get a result and if to add the specific period in which there is a sign of 'True', everything is OK
{ FILTER ({ TM1SubsetAll ([Accounts]) }, [Cube_A]. ([Dim_A1]. [Element_1], [Period]. [2015-01]) = 'True') }

I understand expression of CurrentMember has to return the member of dimension Period chosen in Cube_B?!

The CurrentMember function is only going to work in a view on Cube_A because that's where the context. How is the function supposed to know what the "Current Member" of a different cube view is? What if you had 10 different views open for Cube_A, each with a different selection for Period. Which one would TM1 use to evaluate CurrnentMember? See the dilemna?

Thank's,
How I can create dynamic Subset in dimension Accounts?

Cog1 wrote:How I can create dynamic Subset in dimension Accounts?

The same way you would do for any other dimension.

So doesn't suit me, I described requirements for dynamic Subset creation above. I need create Subset from Cube_A

Cog1 wrote:So doesn't suit me, I described requirements for dynamic Subset creation above. I need create Subset from Cube_A

I'm sorry if I've answered the question you asked instead of the question you wanted to ask.

Please see attached file. I need create dynamic Subset in dimension Accounts, example:
Picklist = {FILTER( {TM1SubsetAll( [Accounts] )}, [Cube_A].([Dim_A1].[Element_1],[Period].[2015-01]) = 'True')}

I gave you a link to documentation on how to create dynamic subsets from Subset Editor. Make some effort and clik around the User Guide and you're guaranteed to find exactly how to create/update a subset when you have your MDX written manually.

You can also create dynamic subsets using TI script, but I'm feeling too lazy to provide the link to the specific functions you'd need to use. I'm sure you'll find someone else to serve it to you on a silver platter.