Hi,
It is based on a proposal given by client and I would like to know is there any method in TM1 to get the number of elements in a cube?
Becasue some senario users want to see how many elemtns was there in cube.
Thanks and Regards
Pradeep Jagadeesan
Number of elements in a cube?
-
pradeep.k.jagadeesan
- Posts: 28
- Joined: Tue Jun 16, 2009 1:03 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.5.1
- Excel Version: 2007
- Location: India
-
Alan Kirk
- Site Admin
- Posts: 6654
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Number of elements in a cube?
How many elements (by which I assume you mean "values") there can be?pradeep.k.jagadeesan wrote:Hi,
It is based on a proposal given by client and I would like to know is there any method in TM1 to get the number of elements in a cube?
Becasue some senario users want to see how many elemtns was there in cube.
Thanks and Regards
Pradeep Jagadeesan
Take the total number of elements in each dimension of the cube and multiply them by each other. If you only want to know about potential stored rather than calculated values (assuming no rules), take the subset of N level members rather than all elements.
How many values there are?
Turn on Performance Monitor and look at the }StatsByCube cube.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.