TM1 Forum

Posted: **Tue Feb 16, 2021 4:46 pm**

Hi Mates,

i tried to make a new dynamic subset based on my very low MDX skills and figured out a problem, may someone can help me out.

Code: Select all

{
	Filter({
		[GuV Gliederung].members
	},[GuV Gliederung Attribute].([Jahre]. [2021], [Version].[Version].[Prognose 4],[GuV Gliederung Attribute].[Köpfe])>1)
}

i Filter the Dimension "GuV Gliederung" and look in the Cube "GuV Gliederung Attribute" for the "köpfe" measure if its greater then 1 add the element so the subset.. So this works fine, but i want that the subset is Dynamic according to the Version and Year (Jahre) selected in the Cube.

I tried this with [Jahre].CurrentMember , but it doesnt work, i think cause its "just a subset" and it cant get the selected value from the cube viewer.

Is there any Workaround for this?

Thanks and BR

Posted: **Tue Feb 16, 2021 4:53 pm**

The CurrentMember method as you have suggested should work but you need those dimensions to be in the Title Elements/Context area, it won't work if you have them as rows or columns.

Posted: **Tue Feb 16, 2021 5:09 pm**

Oh nice i see if i put them up and reload it loads the subset, thank you!

But one other thing

it just shows me everything above the 0 Level but i just want to see the 0 level elements.

Code: Select all


{
	Filter({
	TM1FILTERBYLEVEL({	[GuV Gliederung].[GuV Gliederung].Members}, 0)
	},[GuV Gliederung Attribute].([Jahre].CurrentMember, [Version].[Version].CurrentMember,[GuV Gliederung Attribute].[Köpfe])>1)
}

i tried to add afilter but this doesnt solve it, also my drilldown doesnt made it.

Would be very nice from you if you could help me again

Thanks for it!

Posted: **Tue Feb 16, 2021 6:21 pm**

Try this:

Code: Select all

Filter(
    TM1FILTERBYLEVEL(	[GuV Gliederung].Members, 0),
    [GuV Gliederung Attribute].([Jahre].CurrentMember, [Version].CurrentMember, [GuV Gliederung].currentmember, [GuV Gliederung Attribute].[Köpfe]) > 1)

The difference is this is telling the filter condition to explicitly use the current member of [GuV Gliederung].

NOTE: if you have leaf elements that are under multiple consolidations, .Members will return every occurrence of the members. TM1SUBSETALL( [dimname]) will return just the unique members.

Posted: **Tue Feb 16, 2021 8:05 pm**

Hi,

Edit:

Worked, i missed that the 1 Values in this cube has a weighting so i have to change the ">1" to a "=0" and your statement worked perfectly

Thank you so much for your help!

TM1 Forum

MDX Dynamic Subset with Value from other Cube

MDX Dynamic Subset with Value from other Cube

Re: MDX Dynamic Subset with Value from other Cube

Re: MDX Dynamic Subset with Value from other Cube

Re: MDX Dynamic Subset with Value from other Cube

Re: MDX Dynamic Subset with Value from other Cube