Hi ,
Please avoid duplicating questions, we could discussing the question in your old post.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
SSAS MDX Default the dimension attribute
Hello,
Good evening. I do have a vague requirement where we need to overwrite the dimension attribute to one particular attribute value. This is the data on how it is coming from the backend and the default display of the selection.
Sales Location (Dimension attribute) - Total Sales(Measure)
LOC1 --- 100$
LOC2 -- 50$
LOC3 -- 70$
The expected functionality which we want to achieve here is that we need to explicitly bind the Total value to LOC1. When the Sales location attribute is selected from the Location dimension and when we brought the Total Sales measure, The total should be allocated to the LOC1 attribute.
LOC1 --- 220$
The first option is to default or hard code the SK at the backend view but there is a complication as this dimension is a mix of few other attributes and we shouldn't go with that approach. Is there any chance to write any MDX scope function to achieve this functionality?
Any inputs would be very much appreciated.
Thank you
Hi ,
Please avoid duplicating questions, we could discussing the question in your old post.