Cognos variables

[handpass]

I would like to store a value in a variable and then use this variable in a calculation with a value from a similar but unrelated record.

For example in Record A, I am receiving back the finishing time of a task. In Record B, I am receiving back the starting time of the new task. The calculation that I want to perform is to get the difference between the finishing time in Record A and the start time in Record B, i.e. how long is the system idle. (FinishingTime - NewStartTime = IdleTime)

As there is no common link between these two records is there anyway to store these values in variables so that I can use them later.
Thanks in advance.

 

[GJParker]

Without knowing which application you are using we can't answer your question.

Gary Parker
MIS Data Analyst
Manchester, England

 

[handpass]

Sorry, I'm using Report Studio, Cognos 8

 

[mfgf]

Hi,

I don't think you will be able to do this using the solution you're considering. My feeling is your best bet will be to try to join record A to record B in your report (bring them in using separate queries and add a join object between them [if possible]) so that both dates are on the same joined row.

Without seeing your data it's difficult to say how easy/hard this will be.

Regards,

MF.