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.
Tagged:
0