| |
| | Microsoft OLAP by Mosha Pasumansky : Wednesday, October 25, 2006 - Posts (Site not responding. Last check: 2007-10-03) |
 | | 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. |
 | | Assuming that Calendar and Fiscal hierarchies share some attributes - which is almost always a case, for example, in AdventureWorks they share month and date attributes - the formula returns wrong results for the beginning of the year for one of them. |
 | | But we also note, that since dimension table in AdventureWorks is really built to fit the Fiscal calendar, i.e. |
| www.sqljunkies.com /WebLog/mosha/archive/2006/10/25.aspx (2532 words) |
|