Create and handle surrogate keys for dimensions in Datasphere

[frietschh]

SAP Datasphere 

Created a dimension table with an ID column as key, a NAME column as the business key plus some other columns. The ID shall be a surrogate key, NAME is the business key

How to create values for the surrogate key column in Datasphere? Is there anything like SEQUENCE in an Oracle RDBMS? Is UUID the correct data type for such an ID column? The SYSUUID() function does not work in Datasphere, only in HANA...

Any ideas?

[Martin_Kuma]

the HANA functions can be used in the DB explorer, but this is for admins only (and each click, typing takes like ages... similar to webIDE), but there you have access like from HANA studio. 

[frietschh]

Thanks for the feedback. I have now found this blog entry https://community.sap.com/t5/technology-blogs-by-sap/how-to-auto-generate-ids-for-primary-foreign-ke... which shall solve my challenge. In general this works, need to test it in a "real" data flow...