Hi,

I need some advice regarding calculating the measure from the
dimension.

My structures:

Fact_Policy
Fact_Key
Policy_Key
Amount

Dimension_Policy
Policy_Key -> link to Fact

Dimension Product Allocation
Product_Key -> link to Dimension Policy - snowflake
Policy_Key
Allocation_Pct


I would like to calculate: Amount * Allocation_Pct.

May I know what is the best way to compute in Analysis service?

regards,
mangorind