You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Possible to retrieve a numeric value and refer it it as a member name?

Received Response
5
Views
2
Comments
edited Apr 24, 2019 1:22PM in Essbase 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!