Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: appleglaze28 on 05 Dec 2014 09:45:30 PM

Title: how to group data item members into 1
Post by: appleglaze28 on 05 Dec 2014 09:45:30 PM
I'm using tm1 as my source, i have a report that need to show all accounts with top 10 items and the remaining to fall under OTHERS.

Can anyone help me figure how to make it work.
Title: Re: how to group data item members into 1
Post by: MFGF on 06 Dec 2014 09:36:29 AM
Quote from: appleglaze28 on 05 Dec 2014 09:45:30 PM
I'm using tm1 as my source, i have a report that need to show all accounts with top 10 items and the remaining to fall under OTHERS.

Ok. Thanks for sharing :)

MF.
Title: Re: how to group data item members into 1
Post by: BigChris on 08 Dec 2014 01:57:05 AM
QuoteOk. Thanks for sharing :)

That brightened my Monday morning
Title: Re: how to group data item members into 1
Post by: MFGF on 11 Dec 2014 09:15:14 AM
As you're using TM1, you have some handy dimensional functions available to you. The topCount() function can be used on your Accounts members to show the top 10. You can get the remaining members using an except() function, then use an aggregate() summary to get a total measure value for these - ie aggregate([your measure] within set [your set of remainder accounts])

Cheers!

MF.
Text only | Text with Images