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

Generating a sequential, unique ID for a record/tuple?

Summary:

Generating a sequential, unique ID for a record/tuple? 

Content (required):

I need to generate a sequential number for a field to have a unique ID for a record.

For this I wrote a Groovy script that used a substitution variable for this, which worked well and was also fast.

Unfortunately you can only change substitution variables as a service administrator. Which means normal users can't use the business rule and I can't increment the variable. 

If I use a normal field in the Essbase database, the calculation is too slow and especially if many users use the system at the same time, the incrementing is not stable.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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