I have a book with many reports contained in it. The major Dimension used in all of the reports is Department. I have been asked to create a new Report, that also uses Department, but it needs to only display the 0 level and decedents of the selected department. With this in mind, I know that I can't use the standard sync for this report. I decided to use the new Global Variable. I got everything set up, and used the following MDX. Everything looked just as I wanted, except when changing departments on the main selection tab, the report does not update. It is as if the Global Variable does not update after the initial MDX is setup. What am I missing. Is there a simple way to see what the Global Variable is set to such as out putting the value in a text box?

SELECT
{
TM1SubsetToSet([mPersonnelPlanning].[mPersonnelPlanning],"Personnel Services by Job Code","public")
} ON 0, NON EMPTY
{
TM1FILTERBYLEVEL(
DESCENDANTS(
<vDepartment>) , 0)
}*{
TM1SubsetToSet([Project].[Project],"0Level_Active","public")
}*{
[NumberedList].[NumberedList].[1],
[NumberedList].[NumberedList].[2],
[NumberedList].[NumberedList].[3],
[NumberedList].[NumberedList].[4],
[NumberedList].[NumberedList].[5],
[NumberedList].[NumberedList].[6],
[NumberedList].[NumberedList].[7],
[NumberedList].[NumberedList].[8],
[NumberedList].[NumberedList].[9],
[NumberedList].[NumberedList].[10]
} ON 1
FROM
[Personnel Planning]
WHERE (
[Version].[Version].[Adopted Budget],
[Year].[Year].[Current Year])

------------------------------
Jarrod McReynolds
------------------------------

Hi Jarrod

I haven't yet had a chance to play with the new Global Variables. However, just wanted to check - are you not able to just use a normal selector and return the leaves (or descendants) using the Advanced Sync for Descendants or Leaves?

That way a user can select a parent department and it will just show all descendants or leaves in your rows? Is that perhaps what you are after?

------------------------------
Johann Kassier
Enterprise Planning Architect
Fusion 5
------------------------------

Original Message:
Sent: Wed November 12, 2025 12:13 PM
From: Jarrod McReynolds
Subject: Global Variable not updating MDX

I have a book with many reports contained in it. The major Dimension used in all of the reports is Department. I have been asked to create a new Report, that also uses Department, but it needs to only display the 0 level and decedents of the selected department. With this in mind, I know that I can't use the standard sync for this report. I decided to use the new Global Variable. I got everything set up, and used the following MDX. Everything looked just as I wanted, except when changing departments on the main selection tab, the report does not update. It is as if the Global Variable does not update after the initial MDX is setup. What am I missing. Is there a simple way to see what the Global Variable is set to such as out putting the value in a text box?

SELECT
{
TM1SubsetToSet([mPersonnelPlanning].[mPersonnelPlanning],"Personnel Services by Job Code","public")
} ON 0, NON EMPTY
{
TM1FILTERBYLEVEL(
DESCENDANTS(
<vDepartment>) , 0)
}*{
TM1SubsetToSet([Project].[Project],"0Level_Active","public")
}*{
[NumberedList].[NumberedList].[1],
[NumberedList].[NumberedList].[2],
[NumberedList].[NumberedList].[3],
[NumberedList].[NumberedList].[4],
[NumberedList].[NumberedList].[5],
[NumberedList].[NumberedList].[6],
[NumberedList].[NumberedList].[7],
[NumberedList].[NumberedList].[8],
[NumberedList].[NumberedList].[9],
[NumberedList].[NumberedList].[10]
} ON 1
FROM
[Personnel Planning]
WHERE (
[Version].[Version].[Adopted Budget],
[Year].[Year].[Current Year])

------------------------------
Jarrod McReynolds
------------------------------