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
------------------------------