COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: subhash on 27 Nov 2007 05:42:08 AM

Title: hi
Post by: subhash on 27 Nov 2007 05:42:08 AM
hi,
   i have some doubts in common functions.

why these are used: ancestor,ancestors and etc.
Title: Re: hi
Post by: MFGF on 27 Nov 2007 07:34:57 AM
Hi,

The ancestor function is used with a dimensional package, and allows you to get hold of a specific member's ancestor member at a higher level of the hierarchy.

The ancestors function does a similar thing, but is used in a situation where a member can link to more than one parent at the next level above, so this time the function returns the specified member's ancestors at a higher level in the form of a set.

You can get a good idea os what functions are used for if you click once on the function name while building an expression - the Information window gives you an overview of the function's purpose and syntax.

Regards,

MF.