Hi,
I have some issues with delta loading to NDSO. The RecordMode logic works differently than it's described in documents about NDSO, presentations and so on.
I use an example like in default DWF template (DWF 2.0 SP05) which loads data from ta...
Hi Experts
I have some problems with deploying Data Warehouse Foundation projects. Default DWF project made by standard template (without any modifications) can’t be deployed.
I have HANA Express, version Hana2SP04, DWF SP05, 24 gb memory. Two ...
Introduction
I’d like to share my experience and to analyze possible solutions for a BW task which I’ve met on several retail projects.
I think this problem is quite interesting because it’s one of the examples of the general idea: how can we avoid ...
Hi,
I met strange behaviour of generic extractor - it works in delta-mode,
despite the fact that the name of field for delta is not set in RSO2 in ERP.
The extractor is made on the EBAN table (purchase documents) withou...
Introduction
I'd like to share my experience in developing "pseudo-realtime" in BW systems without HANA with large data volume.
I met this task on one retail project. The client wanted to update data in analytic reports every 15-20 minutes - main tr...
You should convert all NULL values to empty values depending of data type.For example, if your transformation is in "HANA runtime" mode, you can use "coalesce" operator somewhere in your transformation - in field routine or end routine.coalesce(Field...
When you create DataSource on HANA source system, switch on delta handling at "extraction" tab, and you'll see parameters for delta field, safety interval and so on. It should look like this:
Yes, it's possible. Just select a field which can be used as a delta pointer in your data model (like document date). But if this field is date (not timestamp) then safety interval should be used to prevent the loss of some data.https://help.sap.com/...
Hi,Why do you want to extract MSEG data directly from HANA? It's a ERP table, so the best way is to use standard ERP logistic extractors (2LIS_03_BF and so on) and business content for inventory management in BW. With such approach delta will be supp...