I'm new to SSAS and really confused... I'm creating a cube for "Accounts", each account can belong to N categories, I created a "bridge" table on my model where I say:
Account 1 - Category 2
Account 1 - Category 3
Account 2 - Category 2
....
I dont know how to use SSAS to use the bridge table accordingly so whenever I'm browsing the cube using DimCategory and another dimension, lets say DimTerritory I get a proper count. Can you tell me how should I proceed?
Thanks.
Hi,
take a look into Many-to-many dimensional modeling paper from Marko Russo.
It's really good stuff about problems like your one.
No comments:
Post a Comment