Is it possible to assign dimension members to a number value and use that in calculations.
I want to create 2 custom dimension eg- dim1 and dim2.
The dim1 will have members like mem1,mem2, mem3 and dim2 will have mem4,mem5,mem6.
I need to assign values like 5,10,20 etc for this members and use that in calculation. Please let me know if I can achieve it in HFM and how.
Thanks