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?!
MDX expression "CurrentMember" doesn't work
-
- 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
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?
-
- 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
Thank's,
How I can create dynamic Subset in dimension Accounts?
How I can create dynamic Subset in dimension Accounts?
- 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
The same way you would do for any other dimension.Cog1 wrote:How I can create dynamic Subset in dimension Accounts?
Kamil Arendt
-
- 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
So doesn't suit me, I described requirements for dynamic Subset creation above. I need create Subset from Cube_A
- 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
I'm sorry if I've answered the question you asked instead of the question you wanted to ask.Cog1 wrote:So doesn't suit me, I described requirements for dynamic Subset creation above. I need create Subset from Cube_A
Kamil Arendt
-
- 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
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')}
Picklist = {FILTER( {TM1SubsetAll( [Accounts] )}, [Cube_A].([Dim_A1].[Element_1],[Period].[2015-01]) = 'True')}
- Attachments
-
- Tm1Forum_DynSubset.xlsx
- (13.02 KiB) Downloaded 373 times
- 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
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.
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