How do I define temporary variables in the Cognos Report Studio expression definition?
Hello,
I am using the IBM Cognos Report Studio for Insight report development and I am trying to create a calculated Data Item. Since I have to perform some string manipulation, I would like to know how to temporarily define a variable to store data within the Expression Definition.
Is this possible?
Thank you and best regards,
Andrew
Accepted answer
Hi Andrew,
Have you tried just creating a Data Item to do your string manipulation, and then referencing that Data Item within another Data Item in the same query? I've done that before when we have some complex manipulation or calculation as I test my report to ensure the data is being calculated correctly. This way when you "view tabular data" for that query you can see how the pieces come together.
Hope that helps!
Jackie
Have you tried just creating a Data Item to do your string manipulation, and then referencing that Data Item within another Data Item in the same query? I've done that before when we have some complex manipulation or calculation as I test my report to ensure the data is being calculated correctly. This way when you "view tabular data" for that query you can see how the pieces come together.
Hope that helps!
Jackie