I have a serious problem when I explore my Dw Model. I have one Fact table and Two Dimensions:
Brand Dimension and Department Dimension.
Both Dimensions share at Top Level Company Attribute. The Schema is like this :
Brand Dimension : Brand (Brand Table), Brand Group(Brand Group Table), Company (Company Table)
Department Dimension : Department( Department Table), Department Group(Department Group Table), Company (Company Table)
Almost forgot..The Company attribute is present on all tables because is a key member.
At this point everything was ok. But when I started to explore on AS (Browser) my problems has just started.
I realize that, for AS, the Company attribute is not the same for both Dimensions.
When I filtered by Company from Department Dimension I saw all Companies from Brand Dimension.
Naturally I wish to see the same Companies only.
Thanks a lot