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 |
Filaretos
Starting Member
1 Post |
Posted - 2008-02-21 : 13:23:09
|
Hello, I want to create a report in SSRS against a cube in SSAS 2005.I have a Sales fact table, a Products dimension which is related directly to the fact table, and a Categories dimension which is related to the fact through Products (referenced dimension). Categories --> Products --> SalesThe Categories dimension also contains a parent-child hierarchy. Only leaf category members are joined to Products.Is it possible to create a report, drilling down from root categories --> child categories --> products?I 've already implememted the categories parent-child report but when i add the Products dimension in the flattened rowset in RS, the Products seem to be joined to non-leaf category members. So, when a expand the root memeber, besides child categories, it also contains Products!Thanks.Phil |
|
|
|
|