Extract data from model SAC_STATISTICS_MDS_QUERY_PERF using Data Export Service API

[#1]

In SAC, is there a way to extract the data from model SAC_STATISTICS_MDS_QUERY_PERF using the Data Export Service API?

Thanks.

Regards,

Mel Calucin

[DebjitSingha · Accepted solution]

Hello mel_calucin,

Unfortunately you can not use export API to extract data from live models. SAC_STATISTICS_MDS_QUERY_PERF is based on live HANA model (imbedded SAC HANA CV)

I am not entirely sure about your use case here. Assuming you may benefit from - our of the box simple options here are is an alternate option: Exporting a Model to a File

Here is something for additional reading:

https://blogs.sap.com/2022/05/04/sap-analytics-cloud-export-data-api-sample-scripts/

Consider below points before considering Export Data API for your use case:

• API works on Acquired models (analytical and planning) only.
• Beside the use of API is limited. Production models' usually end up with data access control. This is general setup where we want to restrict access based value of a given dimension ( say Cost Center). Use of API is not feasible in this scenario.
• Say your model involve hierarchies, use of API may not make sense as, API will not return
• In case your model include calculated measure/ account dim, your export will not consider these additional objects. Now this may not be a deal breaker as you can setup this in target system as well.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit

[MelCalucin · Accepted solution]

Good to know.

Thanks!

-mqc

[VijayetaSharma]

Don't think live data-source will be supported for extraction anytime soon. Exporting to File server would be option.

Thanks,

Vijayeta