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

i have measure open balance particular account. users want able have hierarchy can bucket dollar balances 0-500,500-1000, etc.

is way creating dimension defines hierarchy. there other methods providing functionality users.

if want hierarchy proposed way best solution, yes. dimension can derived fact table simple sql query such

select case when balance >= 0 , balance < 500 1  when balance >= 500 , balance < 1000 2 end balancegroupid, case when balance when balance >= 0 , balance < 500 "0 - 500" when balance >= 500 , balance < 1000 "500 - 1000" end balancegroupname 

hth