Thank a lot Hubert, it worked perfectly :D
------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole
M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------
Original Message:
Sent: Mon November 07, 2022 04:55 AM
From: Hubert Heijkers
Subject: How to get top parent of an element MDX
Instead of maintaining an extra attribute (unless you happen to have it already), you could simply use the MDX function Ancestor in this case as well as something like:
WITH MEMBER [FG_Mois].[FG_Mois].[TOTAL_ANNEE].[Societe] AS ANCESTOR([FG_Section].[FG_Section].CURRENTMEMBER, [FG_Section].[FG_Section].[Level000]).NAME
------------------------------
Hubert Heijkers
Original Message:
Sent: Fri November 04, 2022 05:27 AM
From: James McCarthy
Subject: How to get top parent of an element MDX
You could write the top parent into an attribute and use the code I gave you previously to pull it out?
Does the dimension change frequently?
------------------------------
James McCarthy
Original Message:
Sent: Wed November 02, 2022 12:54 PM
From: Duong DAU
Subject: How to get top parent of an element MDX
Problem solved ! it should be .CURRENTMEMBER.Parent.Name
Hi community,
I want to get top parent of an element in MDX and i get this #error (recursion)
Can someone help to understand why and how i can fix it?
My code : WITH MEMBER [FG_Mois].[FG_Mois].[TOTAL_ANNEE].[Societe] AS [FG_Section].[FG_Section].CURRENTMEMBER.Parent
Any help will be appreciated!
Best regard!
------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole
M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------
#PlanningAnalyticswithWatson