Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
glennbuteau
Starting Member
1 Post |
 Posted - 2005-03-03 : 16:12:21
|
| Hello,I would like to exclude any members in my dimensions that do not join to the fact table. It seems that when Analysis Services does the join in the cube building process, it restricts only records in the fact table, but all records in the dimension tables are kept.I could filter the dimension data out in the base tables before building my cube, but they are shared dimensions and each cube uses a different subset of the same dimension.Is it possible to restrict dimension members based on the results of the fact table join when building my cubes?ThanksGlenn |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-03 : 16:54:15
|
| You can set a dimension filter.Another trick is to include the facttable in the dimension editor, this will effectively filter the dimension.rockmoose |
 |
|
|
|
|
|
Dimension Filtering