Record count in cube in tm1

[R Ambre]

Hi,

In our project we have requirement where in we need to find out how many records are present in one cube.
Is there any way to find out number of records in cube in tm1 ?

Your help is much appreciated.

[dusherwo]

TM1 isn't a table-based database which makes the 'record count' term not appropriate.
Performance Monitor shows (in }StatsbyCube) the number of populated numeric and strings cells, and also the number of stored calculated cells.
Exporting a base level view to a flat file and filtering in Excel can be useful for analysing usage.

[R Ambre]

Thanks for your reply.
Exporting data into flat file will do.

[jimmy_k]

Hi,

In our project we have requirement where in we need to find out how many records are present in one cube.
Is there any way to find out number of records in cube in tm1 ?

Your help is much appreciated.

Create a new measure 'countItems', with a consolidation 'TotalItems', put '1' in every cell and the sum is visible in the consolidation...

[R Ambre]

Thank u jimmy