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 Andrew Trobec selected this answer as the correct answer
Comments
Andrew Trobec
commented Jul 30 '13, 3:43 a.m.
Thanks Jackie, this looks like the way forward! |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.