Time Dimension Time calculations in UDM: Parallel Period (by Mosha Pasumansky)
| Time calculations in UDM: Parallel Period (by Mosha Pasumansky) |
| Written by Mosha Pasumansky |
| Saturday, 19 May 2007 18:31 |
|
Information on how to handle parallel periods with time intelligence, Also Expands on paper "A different approach implementing A Different Approach to Implementing Time Calculations in SSAS by David Shroyer. Comparing current data to the data in the same unit (day, month, week) in the previous period (year, quarter, semester) is one of the most fundamental tasks in the OLAP system. In MDX this is usually archived through the ParallelPeriod function. However, the classic approach to ParallelPeriod doesn't work well in UDM where Time dimension has many attributes and hierarchies, and where symmetric hierarchy structure is hard to achieve across Calendar, Fiscal and other hierarchies. Time Intelligence wizard doesn't address all these issues either. In this article we will discuss strategies how to build MDX Script calculations for parallel period to work properly across all attributes and hierarchies. |
Tags: 2005, article, time dimension
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
