MDX Dynamic Subset with Value from other Cube

[HighKeys]

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

[declanr]

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.

[HighKeys]

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!

[PavoGa]

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.

[HighKeys]

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!