MDX expression "CurrentMember" doesn't work

Post Reply
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

MDX expression "CurrentMember" doesn't work

Post by Cog1 »

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?!
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: MDX expression "CurrentMember" doesn't work

Post by tomok »

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?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

Re: MDX expression "CurrentMember" doesn't work

Post by Cog1 »

Thank's,
How I can create dynamic Subset in dimension Accounts?
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: MDX expression "CurrentMember" doesn't work

Post by qml »

Cog1 wrote:How I can create dynamic Subset in dimension Accounts?
The same way you would do for any other dimension.
Kamil Arendt
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

Re: MDX expression "CurrentMember" doesn't work

Post by Cog1 »

So doesn't suit me, I described requirements for dynamic Subset creation above. I need create Subset from Cube_A
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: MDX expression "CurrentMember" doesn't work

Post by qml »

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.
Kamil Arendt
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

Re: MDX expression "CurrentMember" doesn't work

Post by Cog1 »

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')}
Attachments
Tm1Forum_DynSubset.xlsx
(13.02 KiB) Downloaded 373 times
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: MDX expression "CurrentMember" doesn't work

Post by qml »

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.
Kamil Arendt
Post Reply