COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: Sarayucog on 13 Aug 2010 06:46:47 AM

Title: Is it possible to identify the last record and its timestamp
Post by: Sarayucog on 13 Aug 2010 06:46:47 AM
Hi all,

This question is different from my pervious question.

From the successfull cube is it possible to identify the last record and its timestamp.

If its possible could you please tell me how it is?


Sarayu
Title: Re: Is it possible to identify the last record and its timestamp
Post by: twlarsen on 13 Aug 2010 10:49:59 AM
Why does it matter?

How about letting us know what you are trying to accomplish.  Once the records are in the cube...they are no longer 'records' so the cube can't tell you what the last record is.

You could just query the records on your database and look at at measures on your cube and figure it out.
Title: Re: Is it possible to identify the last record and its timestamp
Post by: Sarayucog on 16 Aug 2010 02:06:26 AM
Hi twlarsen,

I am new to working in Transformer so I am getting some doughts.

Thanks alot for your answer.