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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-05-04 : 02:31:48
|
| Can we apply WHERE clause in a Dimension, if yes how will we achieve this and how will we dynamially pass the parameter value dynamically? |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-04 : 14:18:43
|
| Dynamic filtering of dimensions is not doable.rockmoose |
 |
|
|
JenniferS
Starting Member
5 Posts |
Posted - 2005-05-05 : 14:13:30
|
| I'm not really sure what you have in mind about filtering, but try this. In Analayis Manager, edit the dimension (I know this works for a shared dimension). With the name of the dimension selected, click the Advanced tab. There you will find "Source Table Filter" down the left side. Enter your criteria in this format: "dbo"."TableName"."ColumnName" = <value>. This will allow into the cube only those fact table rows that have this dimension value.JenniferS |
|
|
|
JenniferS
Starting Member
5 Posts |
Posted - 2005-05-05 : 14:17:30
|
| That's not dynamic, but it does filter.JenniferS |
|
|
|
|
|
|
How to Use WHERE in a Dimension