COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: R Ambre on 09 Dec 2015 02:31:26 AM

Title: Record count in cube in tm1
Post by: R Ambre on 09 Dec 2015 02:31:26 AM
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.
Title: Re: Record count in cube in tm1
Post by: dusherwo on 10 Dec 2015 06:19:59 AM
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.
Title: Re: Record count in cube in tm1
Post by: R Ambre on 14 Dec 2015 12:22:42 AM
Thanks for your reply.
Exporting data into flat file will do.
Title: Re: Record count in cube in tm1
Post by: jimmy_k on 22 Feb 2016 07:21:06 AM
Quote from: rasika on 09 Dec 2015 02:31:26 AM
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...

Title: Re: Record count in cube in tm1
Post by: R Ambre on 01 Mar 2016 07:02:02 AM
Thank u jimmy