CODEWITHSUNDEEP
sql-serverssasdimension
Harsha
Harsha

Reputation: 113

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!!!

Upvotes: 0

Views: 46

Answers (2)

Muthaiah PL
Muthaiah PL

Reputation: 1158

Make use of Snowflake Schema (Dimension) Design

For now, you might me having Manufacture as a dimension, you can still achieve this

SELECT [Measures].[Amount] ON 0,
                {[DimManufacture].[SupplierCode].MEMBERS,
                [DimManufacture].[Manufacture Code].MEMBERS } ON 1
               FROM [Cube Name]

As of i understand, i guess this is what you are looking for.

Upvotes: 0

ColinMac
ColinMac

Reputation: 640

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

Upvotes: 1

Related Questions