Virtual Dimensions Created in Version 7.0
Virtual dimensions created in Microsoft® SQL Server™ 2000 Analysis Services are significantly different from virtual dimensions created in SQL Server version 7.0 OLAP Services. Other topics in this documentation describe virtual dimensions created in SQL Server 2000 Analysis Services, unless otherwise noted. This topic describes how virtual dimensions created in SQL Server 2000 Analysis Services are different from those created in version 7.0.
In SQL Server 2000 Analysis Services, you can continue to use virtual dimensions created in version 7.0. However, some limitations apply to version 7.0 virtual dimensions. (These limitations apply to all virtual dimensions in version 7.0.) Also, virtual dimensions created in SQL Server 2000 Analysis Services generally provide better query performance. If you want to overcome these limitations or to gain the performance improvement of SQL Server 2000 Analysis Services, re-create your version 7.0 virtual dimensions in SQL Server 2000 Analysis Services. For more information, see Creating Virtual Dimensions.
The following table summarizes the limitations of virtual dimensions created in version 7.0.
| A virtual dimension | Created in SQL Server 2000 Analysis Services | Created in version 7.0 |
|---|---|---|
| Has a maximum limit of 759 members | No | Yes |
| Can have multiple levels (excluding the (All) level) | Yes | No |
| Must be based on member properties | No | Yes |
| Can be edited in Dimension Editor | Yes | No |
| Can be defined as private using Analysis Manager | Yes | No |
| Can be changed to a regular dimension | Yes | No |
| Can contain member properties | Yes | No |
| Supports the following functions in Multidimensional Expressions (MDX): Cousin, ClosingPeriod, LastPeriods, OpeningPeriod, ParallelPeriod, PeriodsToDate, WTD, MTD, QTD, YTD | Yes | No |
| Can be used to define an OLAP data mining model | Yes | No |