question

GK1009 avatar image
GK1009 asked

SSAS MDX

Hi, I want to create a calculate measure in my SSAS cube using mdx with following scenario .

Its basically a many to many case. I have DimSrc table that have unique transaction types and DimSrcAll table that have all the possible combination. I have a bridge table and created a relationship between DimSrc and Fact table using this bridge table. FactTable has keys present in DimSrcAll table.

Now I want to write a mdx if user selects value from filter(Filter is from DimSrc) like NB then only those records should come come that have NB key in Fact table. And if user selects NB and MB then those values should come that have NB_MB key in Fact table.

Thanks in advance

ssasmdx
manytomany.png (22.7 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.