About zili_zhou

zili_zhou

Background: There are 3 different ways to use SAC Data Export Service API in BW. I have written blogs for each. And the feedback from customers are: BW managed way (Blog 1) is preferred compared to create replication task in HANA Web IDE (Blog 3) or...

zili_zhou

Motivation This blog is about how to use Replication Task in Smart Data Integration to replicate data from SAC to your on premise HANA. You can replicate SAC planning transaction data not only with delta but also only full. The full load also applie...

zili_zhou

Contents Motivation High Level Architecture Design An example how delta data works Working with SAC Data Export Service delta API Enable SAC Data Export Service Check your provider ID Configuration in Postman A test of list all the pro...

zili_zhou

Motivation:[updated on 27.11.2023 with common mistakes or tips in the customers' projects]As planning data in SAC is often changed by business users, these changes need to be replicated to the target systems like BW/BPC, S/4 HANA or Data Warehouse Cl...

zili_zhou

Motivations: In the past two years, I noticed one of the common mistakes when using SAP Data Warehouse Cloud is trying to use SDI ABAP connection for federation. Thus I am thinking of some simple examples to make everyone understand why it will not ...

zili_zhou

@Alex_Acc there is no SDI solution from BW write to SAC. I assume you still use the old way to push high volume of data from BW into SAC, which performance is a known issue.you can refer below about the new Data Import service in SAC. https://communi...

zili_zhou

@andreas_tidl2 it is not clear 100 mio records from SAC to BW is the initial loading or delta. I assume it is initial loading and that is not a very high value. I suggest you start with DP Agent memory 12 GB and monitor the hardware usage closely aft...

zili_zhou

Hi Jai,Cool. I see your target_volume is sum. I assume the result is correct. In such a case before multi-fact in analytic model is there. This can perfectly solve the issue the issue of different granularity of two different fact tables. As a produc...

zili_zhou

Hi Elke,this is a know issue when the SAC has a lot of models. ABAP dialog process will end into timeout error after looping all the metdata. you can use another blog as a workaround. Here you will restrict to a specific SAC model.https://community....

zili_zhou

You can check DP Server traces and might get some more details. I guess it is related to BTP has changed its certificate https://me.sap.com/notes/3327214 try to upload the new certificate DigiCert Global Root G2 into your DP Agent. If issue still ...

User Statistics

User Activity

Configuring Data Export Service: Restricting to a Single SAC Model in BW/4 or BW on HANA

How to use Smart Data Integration Replication Task to get delta from SAP Analytics Cloud to HANA

How to implement the delta logic in SAC Data Export Service Odata API at the Consumers side

Realtime (delta) Data Replication from SAP Analytics Cloud to BW/4 HANA

Why SDI ABAP for virtual access in SAP Data Warehouse Cloud should be avoided

Re: Realtime (delta) Data Replication from SAP Analytics Cloud to BW/4 HANA

Re: Realtime (delta) Data Replication from SAP Analytics Cloud to BW/4 HANA

Re: SAP Datasphere Analytic Model Series Blog Post # 10– Design Multi Fact in Analytic Model

Re: Realtime (delta) Data Replication from SAP Analytics Cloud to BW/4 HANA

Re: Leverage the SAP Analytics Cloud Data Export Service to extract your planning data to SAP HANA, SAP Business Warehouse and SAP S/4HANA