Hello Kumar,
As per my undertanding,DXC is used to replicatte the BI datasources in ECC to HANA.
DXC does not require BW on SAP HANA. Also with DXC, data is not loaded into the embedded BW system. Instead, data is redirected into SAP HANA and that can futhur use for the modelling and reporting. Hope it is useful. Regards, neha
You need to use Infopackages/Process chains within the embedded BW within the ECC system.
OSS note 1583403 and 1665602 has detailed steps required.
Let us say we have a client who is currently on SAP BW and regular delta loads are happening from their ECC System. If we gradually migrate their BW Application to HANA, can have a DXC between the BW System and HANA, and extract regularly from their BW System ?
The IMDSOs would then be generated from "Export Datasources" of Infocubes like 0SD_C03.
DXC is for ECC to HANA using the ECC extractors, they cannot be based on cubes or DSOs.
Why do you want to move data from BW to HANA datamart if BW is already on HANA?
Hi Prateek,
My two cents:
Data loads from ECC to BW on HANA (after gradual migration) can continue and for the standalone HANA you might want to use DXC, if the extractors fullfil the conditions / limitations of DXC. If the DXC cannot be used, you might want to use BODS for extraction.
Regarding accessing the data in BW objects in Standalone HANA, currently there is no direct mechanism for that. Although technically you can access the Infocube fact tables and DSO active data table from Standalone HANA (if both the schemas are implemented on the same HANA serv er), it is not allowed by SAP.
So you might want to have a workaround solution like exporting the data from BW in form of open-hub or something to get the data from BW and load it to the HANA database.
In this scenario, the BW application with all the existing business solution implementation will remain as it is with the transformation and "consumable" data, whereas the Standalone HANA will act as the "Reporting Solution".
It can continue till the entire data model in BW is generated in standalone HANA.
Regards,
Ravi
Hi Ravi,
The only doubt that I have with BO Data Services, is they will not be able to handle the Delta Management from the BW System. This is because Infocubes in SAP BW are being loaded with incremental Data on a daily basis.
My understanding of BODS with SAP is that they can help in extracting data from Infocubes/BeX Queries on a one-time basis and there is no mechanism to get regular updates on a daily basis to stabilise a process.
Same for Open-hub, I am not confident of its capabilities for a regular and smooth flow of incremental data on a daily basis.
That is why I was thinking of DXC from BW to HANA. Like I said, Export Datasources from Infocubes can also be treated as SAP Extractors and to IMDSOs they would be just another extractor, albeit from the BW System.
Regards
Prateek
Hi Prateek,
All BW extractors "officially released" for use with BODS support the init and delta process like you see in BW today. You can use them with ODP (operational data providers) in BODS. So they behave like BW DSO's.
Regards,
Rajiv
Kumar:
Adding to the above points:
DXC can only provide near real-time data replication. Depending on your reporting needs this should be sufficient in most business cases.
The big advantage of DXC is in the landscape and skills required to implement SAP HANA (in other words cost). The key is whether or not the business needs real-time data replication.
If BW extractor in ECC supports DXC and delta loads, implementing DXC should be sufficient. Personally, I am all for DXC.
Regards,
Rama
All,
I'm not sure if Kumar's question got answered and I have a similar question. I've read thru many of the Hana documents and it's not clear how data moves from ECC to BW 7.3 on Hana. Say after BW 7.3 is implement on Hana, 2LIS_02_ITM datasource is activated and Infopackage is created for 2LIS_02_ITM. If I execute the infopackage how does the data get into HANA?
1) Uses the current TRFC process to transfer data to a HANA table(PSA).
2) Uses the DXC functionality.
3) Uses the BODS functionality.
4) Other
My understanding is that option 2 is the normal transfer process for ECC datasources to BW on Hana but I have not been able to confirm this. The only thing I can find is the following link
http://help.sap.com/saphelp_nw73/helpdata/en/62/9d41934c0744ef9a8f21fa4c70baa3/frameset.htm
It has an entry for PSA which indicates a MERGE functionality which tells me it's in the IMDSO architecture which is how the DXC functionality works.
Regards,
Dae Jin
Once you are using HANA only as a run-time database for BW and pulling ERP data into BW, then the standard RFC process is being used.
DXC is used only to load data from ERP into HANA db directly, without any BW on top of it.
Hi Vitaliy,
Thanks for the clarification. So is the PSA a single table or IMDSO in HANA?
Thank you,
Dae Jin
PSA table structure is the same as in non-HANA BW.
Dae:
Vitali is right.
For short, DXC is an alternative solution to using BODS (aka data services) and SLT in the ECC environment. However, you do not get realtime replication.
Hope this helps.
Rama
Hello Rama Shankar,
After reading the entire discussion, i am again confused with DXC.
My understanding is i can use DXC to get the data from ECC to SAP HANA via SAP BODS (using Extractor type) replication is it?
Is there any document or tutorial which explains with example on how can i do this ?
Please help me in this.
Regards,
Krishna Tangudu
Hello Krishna,
You would use this process ONLY if you don't use BW on HANA. So if you have don't have BW on top of your HANA this would would correct in your situation.
Krishna:
DXC is an alternative solution to BODS. If you are using DXC, you do not need BODS or SLT. The only thing with using DXC is that you can not have real-time replication. The data replication will happen on scheduled time intervals with full support to delta extraction provided the source SAP ECC-BW extractor supports delta.
Checkout the SPS4 admin guide for details on using DXC, I also remember reading a DXC guide but can't find it anymore in experienceHANA website.
Hope this helps.
Regards,
Rama
Hello kristna
According to my knowledge if your bw system is not running on hana we will go for dxc connection. After enabling both xsengine and icm service in your hana studio your dxc will be in running mode. After this you have to create a rfc connection in sm59 to hana from bw system. After creating rfc connection go to sa38 and assign your data sources to hana. After doing this 5 tabels will be generated in your hana db corresponding to your dso. After this you have to design a process chain in bw for regular data lodes into hana.
Note: if once a data source is assigned to hana through dxc that data source is no more usefull in your bw system for any etl or reporting purposes.
Regards,
prudhvi
