If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Parent - Child of multiple levels

Started by Hodges, 24 Aug 2014 05:01:17 AM

Previous topic - Next topic

Hodges

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?