SSAS - How do I stop aggregation a attributes from the measure group

Hi,

I've  customer age(current) on the fact table, I dont want users to aggregate the age value, just need to show as non-aditive values, if the selected to the result window.

how do i achieve this?

regards,
k
keplanAsked:
Who is Participating?
 
Rich WeisslerConnect With a Mentor Professional Troublemaker^h^h^h^h^hshooterCommented:
Within BIDS, I believe you should be able to open the cube within the solution explorer.  In the first tab (Cube Structure), you should have dimensions.  Your CustomerFacts should appear in there, with the age(current) as an attribute.  Select properties for that attribute, and change 'AggregationUsage' to 'None'.
0
All Courses

From novice to tech pro — start learning today.