SourceTableFilter (Dimension Interface)
.gif "ms132762.note(ru-ru,SQL.90).gif") Примечание. |
|---|
| В следующей версии Microsoft SQL Server эта возможность будет удалена. Не используйте ее при работе над новыми приложениями и как можно быстрее измените приложения, в которых она в настоящее время используется. |
The SourceTableFilter property of the Dimensioninterface restricts the members included in a dimension.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
String
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
clsDatabaseDimension |
R/W* |
clsCubeDimension |
R |
clsPartitionDimension |
R |
clsAggregationDimension |
R |
* Read-only for virtual dimensions.
Замечания
Use this property to filter dimension members. For example, suppose you want to build a sales cube that only contains customer information from the state of California. You can set this property equal to the following SQL expression to solve this problem:
"Customer"."State" = 'California'
| Примечание. |
|---|
| The expression must be entered in terms of the SQL dialect used on the source server, not Multidimensional Expressions (MDX). Thus "Customer"."State" refers to the State column of the Customer table in a Microsoft® SQL Server™ 2000 database. |
The SourceTableFilter property contains an SQL expression such as those found in SQL WHERE clauses. That is, it must contain an SQL expression that evaluates to either True or False.
For virtual dimensions, this property is always read-only and empty.