using Cognos BI 8.4.1 Report Studio accessing TM1 9.5.0 cube. Crosstab report. When selecting members from Insertable Object window for example clicking on hierarchy: market dimension, market hierarchy, Members folder, Buyer_dim, Europe, Germany there are 50 buyers displayed. At the last position of buyer there is Search link displayed. So other users is possible to select only if Search link is clicked and typed in some text to search a buyer.
Is there any way I can do the following:
1. display all members in particular level (instead of just first 50)
2. display like it is now, but with Next button to show next 50 buyers
3. by default display more then 50 buyers like set something like 200 members
Pinned topic How to display more then 50 members in hiearchy in Report Studio?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-08T12:33:01Z at 2013-03-08T12:33:01Z by nvf
OpherB 270003XT4A664 Posts
Re: How to display more then 50 members in hiearchy in Report Studio?2011-05-18T22:19:41ZThis is the accepted answer. This is the accepted answer.I don't work with TM1 cubes, but for PowerPlay cubes you can open the Package Properties and there is a link to "Modify the package configuration...". That page has fields to change the default and maxiumum number of values displayed.
I should point out that this setting will need to be updated every time the Package is republished, a fact that Cognos should fix as a bug....
SystemAdmin 110000D4XK15496 Posts
Re: How to display more then 50 members in hiearchy in Report Studio?2011-05-19T00:11:25ZThis is the accepted answer. This is the accepted answer.
- OpherB 270003XT4A
igorM 110000Q388302 Posts
Re: How to display more then 50 members in hiearchy in Report Studio?2011-05-19T07:32:25ZThis is the accepted answer. This is the accepted answer.
- OpherB 270003XT4A
1. In Cognos Connection I have clicked on More button at package.
2. Clicked on link "Modify the package configuration".
3. Changed setting "Maximum member limit in a data three level" from 50 to 1000.
4. Clicked on OK button to save setting.
Then I have republished package with Framework Manager, just to test if the settings is overwritten and I have found out that this settings is PRESERVED in my case.
So just wondering which version of Cognos BI are you using? In my case it is Cognos BI v8.4.1 and in yours?
Thanks for help.