question

SavitriBiju-5807 avatar image
0 Votes"
SavitriBiju-5807 asked ·

SSAS Measure -> Retrive the selected value from Measure

Hi, I have a hierarchy HL1 HL21 HL211 HL212 HL22 HL221 Users access this cube data in Excel. They place this hierarchy in the COLUMNS section of pivot. The result should be as below in the image. ![72489-capture.png][1] [1]: /answers/storage/attachments/72489-capture.png Basically when the user selects HL21 in the hierarchy and is at that level, it should show the balance for HL21 i.e. 600$ However when the the user drills down to the next level -> excel displays HL211, HL212, HL213 -> the new measure should still show the balance of HL21 -> $600 Please help.

sql-server-analysis-services
capture.png (17.6 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered ·

This should be a MDX issue for SSAS multidimensional cube ?

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am sorry , if we have not helped on this case. But hope you didn't mind that we need to confirm the request or question first before working on it.

0 Votes 0 ·