Best practice for creating a hierarchy of dollar bracket measures in SSAS

I have a measure for open balance for a particular account. My users want to be able to have a hierarchy that can bucket dollar balances into som开发者_如何学编程ething like 0-500,500-1000, etc.

Is the only way to do this by creating a dimension that defines that hierarchy. Are there any other methods for providing this functionality to users.

If you want it as an hierarchy your proposed way would be the best solution, yes. The dimension can be derived from the fact table with a simple SQL query such as

SELECT CASE WHEN balance >= 0 AND balance < 500 THEN 1 
WHEN balance >= 500 AND balance < 1000 THEN 2 END AS balanceGroupID,
CASE WHEN balance WHEN balance >= 0 AND balance < 500 THEN "0 - 500"
WHEN balance >= 500 AND balance < 1000 THEN "500 - 1000" END AS balanceGroupName

HTH