Could someone please help me with the following scenario,
We were pulling line items data into BI from FI-GL, using 0FI_GL_4. So far we were loading into DSO and then into Cube for speedy reporting.
As maintaining the same records in Cube and DSO not a good practice as it needs 2TB of extra memory for 2yrs of data at any time, we would like to remove DSO totally and load into Cube (line-items)
My questions are:
Does 0FI_GL_4 supports the delta to load into Cube...means, whether this data source's delta updates new value or just the change?
If you say it does not support, Could you tell me the best practices to improve the reporting performance when we do reporting on DSO (of course drill down from summary Cube)? Like splitting, indexing, etc and also please let me know the performance gain compared to reporting on cube.
on the other way around, Could someone tell me, what are the issues in designing and developing generic data source with delta that supports delta update into InfoCube directly.
Hope you will help with these,
Any Help would be greatly appreciated with POINTS.
Thanks in Advance