If you would like to create a crosstab that calculates the difference between columns as shown below:
Create a calculated Measure running-difference([Revenue]) where [Revenue] is the measure for which you wish to calculate the difference.
Some questions that I have with the above method is that running-difference is not available in the list of functions when you use a dimensional model. This is a relational function that we are using against a dimensional model, so I am not sure of the performance impact that this would have.
What other information that I have noticed is that no longer does the Native SQL gets generated. Only the Cognos SQL gets generated. Once the running-difference item is deleted then the Native MDX gets generated.
So now, my question is why doesn't Cognos include a lot many functions as part of the dimensional model function set? This causes a lot of issues for the developers.
Popular Posts
Friday, March 5, 2010
Subscribe to:
Post Comments (Atom)
1 comment:
Hi Zephyr,
How do you create optional prompt pages?
Thanks,
Dave
Post a Comment