cancel
Showing results for 
Search instead for 
Did you mean: 

API/SDK to automate model creation in SAC without user interaction

clovisribeiro
Discoverer
0 Kudos

Is there a REST API (or SDK in C/C++, Java or any other language) to automate the process of creating a new model? We want to create a complex model with multiple dimensions (using hierarchies) and multiples measures with different types of aggregation and do not want users to have to do it manually. We want to automate the whole process as we already have all cube definitions and star schema tables ready in an on-premisses system.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

You can look on "Deployment/Export" results to generate the same...

Answers (3)

Answers (3)

Thomas_Häusel
Advisor
Advisor
0 Kudos

Hi, there are is a REST API available for SAC:

https://help.sap.com/doc/14cac91febef464dbb1efce20e3f1613/release/en-US/index.html

But currently it has limited functionality.

Additional it is possible inside the SAC Application Designer to script with Javascript and to automate a few things.

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/fcc3d4dcbac0403d9ac191628...

To build or rebuild a complete model, I think is currently not possible.

clovisribeiro
Discoverer
0 Kudos

Thanks for your comments Vadim. Our cost management product already has all cube/model definitions, so we do not want to have our users do the work twice. In addition to that, our users might create more than one costing model, so they would not have a one time job but multiple times.

Just as an example, we can easily automate SSAS or even Oracle OLAP using their APIs so that we can create cubes/models in SSAS and Oracle OLAP on the fly. It is hard to believe SAP does not do that yet.

former_member186338
Active Contributor
0 Kudos

It's one time job, why do you need to create a code to do this job?

To my mind the API is not available!