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 |
|
hennie7863
Starting Member
12 Posts |
 Posted - 2011-10-24 : 03:05:46
|
| I've a question about the following schema:Type (dim) -> FactA FactA DD (dim) -> FactA Date (dim)-> FactA FactA DD (dim) -> FactB Date (dim)-> FactB FactA = eg OrderFactB = eg. orderlinesFactA DD dimension is a Factdimension of FactA en i've a FK column in FactB to this FactA DD dimension (in the dimension usage tab).What if i want to select (filter) with the Type dimension records in FactB? As i know now the same value is shown when browsing the cube. Is it possible to filter some records from the Type dimension and show only the relation records of FactB? Or should i include the Type dimension in FactB also? This doesn't seems a good solution to me..Hennie//edit: |
|
|
|
|
|
Select factrecords with dimension of other fact