AS 2005: Where are Parallel Period calculations in the Business Intelligence Wizard

I am using the July CTP of SQL Server 2005.

Books Online indicates that the Business Intelligence Wizard in the BI Development Studio supports parallel period calculations. I did not see this class of calculations in the list.

The available calculations were Year to Date, Quarter to Date, Month to Date, Twelve Months to Date, Twelve Month Moving Average, Six Month Moving Average, Three Month Moving Average, Year Over Year Growth, Year Over Year Growth %, Quarter Over Quarter Growth, Quarter Over Quarter Growth %, Month Over Month Growth, Month Over Month Growth %, Day Over Day Growth, Day Over Day Growth %. I would have expected calculations like "Period Prior Year" or "Prior Period"

Is there something special I need to do to make the parallel period calculations available? Or are they just not yet available in the July CTP?Kendal,

When BOL states "Parallel period comparisons", it is referring to the "... Growth" and "... Growth %" calculations that are available. For example, the "Year Over Year Growth" calculation will return the difference between measures for a period in one year compared to the same period in the prior year (whether the period selected is a quarter, month, week, or day).

Let me know if that is not the type of parallel period calculations you are wanting...

Dave Fackler
|||

You have clarified it for me.

I had previously created and used more direct period calculated measures like "Value in prior period" or "Value for same period in prior year". I expected to see those as well. But we can create those on our own based on the provided templates.

Thanks for the response!