Search code examples
sql-serverssasdimension

SSAS Dimension relationship

I have two dimension.

one is Manufacturer

enter image description here

Other is Supplier.

enter image description here

Have a fact table.

enter image description here

Need to query the sales amount using supplier code, also want to see the relation between Supplier and Manufacturer against sales amount. Can this be done.

Is there any possibilities that can be achieved without adding a supplier key to fact.

Please help!!!

Solution

  • You cannot query sales amount using supplier code because the manufacturer(int)|Amount($) pair doesn't uniquely identify supplier.