SAP Analytics Cloud - Planning - Generate unique number

[sssridhar]

Hi,

Story created from the Planning datamodel.

After selecting 'Add member' new blank row will be created, in blank row in one of the dimension name is unique number, can the value in that dimension automatically updated without manually typing (eg. UID2).

(or)

Calculated dimension can be created with combination of other dimensions to create unique id. Is that calculated dimension store back to datamodel.

requirement is to have unique numbers in the datamodel without manually typing in the story.

Please reply for any solution or additional details.

Thanks

Sridhar

[JefB]

Hi Sridhar,

Not possible in SAC stories.
The 'Add member' functionality in stories is just too limited.

You can however customize something in application designer with master data API's
See here for an example: https://blogs.sap.com/2020/06/02/maintain-master-data-in-planning-model-sap-analytics-cloud-sac/

But a lot more effort & specific skills are needed.

[sssridhar]

Thanks, will check and get back.