cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a view detailing users that have been assigned to spaces

klorn_pallier
Explorer
0 Kudos

I'm wondering if it is possible to create a view detailing what users that have been assigned to what space? I've tried find this data in the SYS and DWC GLOBAL sources without success. Can anybody help please?

Accepted Solutions (0)

Answers (1)

Answers (1)

Cocquerel
Active Contributor
0 Kudos

Using DWC-CLI command line tool, you can get the space definition including members in JSON format, see https://help.sap.com/docs/SAP_DATA_WAREHOUSE_CLOUD/9f804b8efa8043539289f42f372c4862/5eac5b71e2d34c32...

Such command line tool can be called from HANA using SDI File Adapter and JSON response be parsed via SQL Script and display as table output of a table function in DWC Open SQL. In the following blog, I have described a similar solution where I'm calling XS command line tool from HANA : https://blogs.sap.com/2021/12/13/manage-xs-advanced-via-sql/