Possible to retrieve a numeric value and refer it it as a member name?
Summary
Investigating the possiblity of storing and retrieving a numeric value, and having a calc scrpt pull the number and then reference it as a member name.Content
The use case is something like this: An employee is 50% allocated to cost center 123, and 50% allocated to cost center 345. Is it possible to store 123 and 345 as values in a cube, perhaps in a 'No Cost Center' member, and retrieve/fix/or store the value in a variable, and then refer it it as a member?
I've done testing on this concept, but I've not been successful. I can store the value to a variable and even set runtimesubvar to that value, but in all cases the script complains that the value is a number and not a string. I've not been able to convert it to a string to be used by
Tagged:
1