SSAS MDX Default the dimension attribute

Pradeep M 21 Reputation points

SSAS MDX Default the dimension attribute


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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points

    Hi ,

    Please avoid duplicating questions, we could discussing the question in your old post.