Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: giovanni.lucarelli on 11 Nov 2008 01:10:59 PM

Title: FM - Sorting Hierarchy for time dimension
Post by: giovanni.lucarelli on 11 Nov 2008 01:10:59 PM
ciao,

does anybody know how to sort a time hierarchy? I should to do this in FM?

thanks very much
Title: Re: FM - Sorting Hierarchy for time dimension
Post by: lindero on 14 Nov 2008 06:04:01 AM
Do you mean the member of a hierarchie level? Do you model DMR?

IMHO, there is no way to sort members at a level. That is a gap in FM.
Title: Re: FM - Sorting Hierarchy for time dimension
Post by: giovanni.lucarelli on 18 Nov 2008 03:47:11 PM
yes, i have a dmr...  :-\ i know how to sort a hierarchy but the fuctions such as prevMember, next, periodsTodate...don't work in dmr can somebody to confirm me this?

thanks
Title: Re: FM - Sorting Hierarchy for time dimension
Post by: cham on 07 Dec 2009 06:14:56 PM
hi Giovanni,

Can you please let me know how to sort a hierarchy/level in DMR? I need it urgently.

thank you in advance.
Title: Re: FM - Sorting Hierarchy for time dimension
Post by: david.stachon on 08 Dec 2009 11:41:32 AM
unbelievably, they only introduced sorting into DMR in 8.4.

...is that what version your on?
Title: Re: FM - Sorting Hierarchy for time dimension
Post by: cham on 10 Dec 2009 07:02:29 AM
Nope. We are using 8.3.

Is there any work around for those versions?
Title: Re: FM - Sorting Hierarchy for time dimension
Post by: cognos8developer on 03 Jan 2010 09:48:10 PM
Are you refering to sorting in a tree prompt or just a member set in a crosstab?

It is possible to use the order() function and get Ok results in a cross tab, but there is no member sorting in a tree prompt until 8.4.


The you can use functions such as nextmember() etc and get the correct member otherwise the members are often in inconsistant order.

Cheers,
Text only | Text with Images