TM1 equivalent for linkMember () function

[MikeG]

Hi,

I had a problem raised on this site, where the answer was

"the Current Month member is in a different hierarchy from the real month members in your dimension. You can use the linkMember() function to grab the corresponding month member from your real hierarchy."

This seemed perfect until I found the linkMember () function (which seems really useful) is not supported with TM1 cubes.
Has anyone using TM1 found a credible alternative?

thanks
Mike

[Nemo]

Hi,

If I understand correctly you are trying to get Current Month from time hierarchy because the linkMember() function is not supported with Cognos TM1 cubes. If this is the case, then you can get the Current Month out from time dimension with this kind of formula:

item(
filter (
members ([Cube].[DIM].[HIER]);
caption (firstChild([Cube].[DIM].[HIER].[Time All]->:[TM].[DIM].[HIER].[@MEMBER].[MEMBER]))
=
caption(currentMember ([Cube].[DIM].[HIER]))
);0)

Hope this will help you.

BR,

Nemo