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 |
|
lochew
Starting Member
3 Posts |
 Posted - 2006-03-08 : 15:51:54
|
| Hey Everyone,I wanted to know if there is a way to limit the dimensional level data that is only relative to the fact data. Example: Within a dimension call store I have a listing of all my stores Store1, Store2, Store3. If I only have Fact data for Store1 how can I make only this store visible within the Store dimension then as fact data comes available for Store2 have MSAS make available this information. Currently it displays all stores but has no values. When displaying this cube within Cognos Power Play I see all the Stores but have zeros for the measures. If I suppress zeros within Power Play it hides the stores with no data. So my question is as follows: Is there a way to have MSAS hide these members within the level prior to the end users view the cube? I would rather not use zero suppression within powerplay for obvious reason (dimension nesting). Any thoughts on this would be great. CheersLC |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-08 : 20:43:03
|
| I think the easiest way to do this would be to leave the "empty" dimension rows out of the database tables that you load your cube from.CODO ERGO SUM |
 |
|
|
|
|
|
Limiting dimensional data that is only relative to