Hi all,
I'm in the process of creating numerous Variance reports. The report specs call for doing a rolling 4 qtr analysis, in which, for our purposes, the time and variance dimensions are on the x-axis in a CXTab report.
I presumed Cognos would have sufficient examples and documentation discussing such a common business function along different scenarios but I am currently out-of-luck.
Would some of you please explain how you would or have handled Variance reporting and what are some best practice(s) to be employed when working with variances?
Example of some reports are (horizonally)
Q1 Q2
Units Dollars Price || Units Dollars
Q3
Price Price Var (q1-q2) || Units Dollars
Q4
Price Price Var (q2-q3) || Units Dollars
Q4
Price Price Var Var(q3-q4)
Thanks!