on 06-06-2011 10:04 AM
Hello Everybody,
I am getting dump while data loading from DSO to Cube.My data flow is from PSA(0fi_gl_10) to DSO(0figl_o10) to Cube(0figl_c10).
Dump is DBIF_RSQL_SQL_ERROR. I guess this error is because of huge amount of data that is coming while full load.It's almost
65L records which are coming and which is creating problem.So the strategy that I am following is doing int without data transfer first without any selection criteria and then doing full load on yearly basis. i.e. from 2004 to 2005 then 2005 to 2006 and so on so data will come in chunks and I can go ahead then.My area of concern is when I'll run delta will it lead to any data duplicacy, also in my case I have DSO in between(which can handle data duplicacy problem) but if only cube is there then how can we achieve the same.
Any help will be appreicated.
Thanks,
Mayank
After running the Delta W/o data transfer, you will run the Repair Full Load & load the data in chunks.
This will not disturb your Delta.
It is always recommended & it's a mandate w.r.t FI related data, that the DSO be positioned in between the datasource & the infocube.
After your Repair Full loads, even if there is a change in the record and that is picked up in the Delta, your DSO should take care of it & send the change records to the cube.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure if you're aware but FI datasources always have a DSO in between.
You cannot have the Delta directly flowing into the cube.
Please have a look at the below links:
http://help.sap.com/saphelp_nw2004s/helpdata/en/41/4b73415fb9157de10000000a155106/content.htm
http://help.sap.com/saphelp_sm32/helpdata/en/45/757140723d990ae10000000a155106/content.htm
If you are looking at other datasources (different functional area), then it depends on your requirement how the Delta fits in it.
Edited by: Vishal Sanghvi on Jun 6, 2011 11:27 AM
User | Count |
---|---|
85 | |
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.