Help / Advise regarding Variance reporting

[Amant]

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!