hi

[subhash]

hi,
   i have some doubts in common functions.

why these are used: ancestor,ancestors and etc.

[MFGF]

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.