Very simple Q, BottomCount doesn't work?

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:
Contact macsir

Very simple Q, BottomCount doesn't work?

Post by macsir »

In a cube view with single row, BottomCount doesn't work as expected? Other options are working fine.
Accdording to Manual, BottomCount is Filters the view to display only the smallest n elements, where n is a number specified in the Value option. Whatever value is set, the final view result is always empty?
Can anyone test it as well? My version is 10.1.1, Thanks. :?
Attachments
2014-06-18_160422.jpg
2014-06-18_160422.jpg (15.6 KiB) Viewed 2110 times
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Top
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:
Contact macsir

Re: Very simple Q, BottomCount doesn't work?

Post by macsir »

Can anyone have a try?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Top
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:
Contact macsir

Re: Very simple Q, BottomCount doesn't work?

Post by macsir »

Got answer by myself. Actually this function works for all elements in that single row even if you suppress zeros. It is comparing all elements in that dimension to get the smallest ones. :mrgreen:
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”