on 06-06-2014 11:46 AM
Hi SCN,
While loading data to 0FIGL_C10 why we need to load the data into DSO (0FIGL_O10) ? Cant we load data with out DSO(0FIGL_O10)?
Please tell me the Significance of DSO in FI DATA LOADING?
Hi Rajesh,
Let us assume a DATA SOURCE for sales with delta AIED
In DSO:
EMP Id SALES QUAN SALES AMT
001 2 20
002 4 40
In CUBE:
EMP Id SALES QUAN SALES AMT
001 2 20
002 4 40
if sales order is changed and quantity is updated to 4 for EMP ID(001)
EMP Id SALES QUAN SALES AMT
001 4 50
DATA in DSO becomes
EMP Id SALES QUAN SALES AMT
001 4 50
002 4 40
DATA IN CUBE BECOMES
EMP Id SALES QUAN SALES AMT
001 6 70
002 4 40
But DATA in cube should be 50 for SALES AMT and QUANTITY should be 4.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandra,
Data in Infocube will be from the change log of the DSO. Please simulate the loading from DSO and to Infocube by checking in change log table after loading the request one by one.
When you do the delta from DSO to Infocube , you will have the below records loaded to Infocube.
EMP Id SALES QUAN SALES AMT
001 2 20
001 -2 -20
001 4 50
002 4 40
Regards,
Rajesh
Chandra,
I agree with Rajesh.
You should understand how AIED delta image works. If you decide to go with delta, you should have DSO, with overwrite mode for all key figures, to get correct values in cube.
Regards,
Raghu
Hi Chandra,
0FI_GL_10 supports the delta image : AIED. ( After-Images with Deletion Flag Via Extractor (FI-GL/AP/AR)
All AIED images need to have DSO and then should be loaded to Infocube as datasource provides only after images and not before images.
You can see in roosource and rodeltam for more information on datasource.
Regards,
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
With or without dso is depend on business needs.
DSO - holds granular data
Cube - holds aggregated data.
if your data source won't supports delta then in such cases we introduce dso between cube and data source. Rather than pulling full load daily needs, from DSO to cube we can load delta loads by using dtp concepts.
By mistake we lost/deleted data from cube, rather than loading from source, we can reload those records from dso(if its have history data.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.