Hi,
I have a union on two descendant calculations so that I have one column with multiple levels in, this is needed for a specific purpose. What I need is another column with the parent of this union calculation but eveything I try return "No Data Available"?
Using the GO DATA WAREHOUSE (analysis) sample package my union calculation is:
union(
descendants([Employee expense].[Time].[Time], 2)
,
descendants([Employee expense].[Time].[Time], 4)
)
I have tried to no avail the following:
parent(currentmember([Employee expense].[Time].[Time]))
and also played with the ancestor functions but still with no results.
Can this be done?