cancel
Showing results for 
Search instead for 
Did you mean: 

After image delta from cube to OHD..

Former Member
0 Kudos

Hi All,

I would like to pick you brains for an issue I am currently facing. There is one requirement that requires us to send delta data in the form of After image to an OHD file from a cube.

The issue is when we get delta data from the cube, we are getting only the additive values. My understanding is that this delta is the aggregation of the Before and After image delta values from the underlying dso.

My issues are:

1. Is there a way of getting the after image delta values from the cube?

2. I do not want to read from the underlying dsos because, some calculations are performed when loading the cubes. Also, the data required is in aggregated on year level. So if we take the data from the dso, which is in day level, we would have to do aggregation manually.

Thanks in advance for your help experts!

Accepted Solutions (1)

Accepted Solutions (1)

anindya_bose
Active Contributor
0 Kudos

Hi

Push your Cube Data to another Standard DSO with all the Key Figure as "Overwrite".

You have to choose Key Fields in DSO based on your scenario. Without knowing the exact Scenario it would be difficult to give you exact answer.

You can also think of APD..

Cube -


>Query -


>Direct Update DSO -


>OHD.

Regards

Anindya

Former Member
0 Kudos

Thanks for the above responses...

Let me give the more detailed scenario..

I have 4 GL cubes whose delta values are required to be exported. They want the delta values to reflect the "As Is",

So for instance we have the following on Day 1:

GL Acc 0Amount

10001 100

The next day, 0Amount(Aggregation mode: Sum) gets an addition of 100, they want to see the following

GL Acc 0Amount

10001 200

These 4 GL Cubes have about 5 common underlying DSOs.

The issues here is:

- If we read the delta directy from Cubes we are getting the addiditive values: in this case +100

- If we read the delta from DSOs, from my understanding we should perform aggregation manually. Since the client wants to view the data by Year instead of by Day which is how it exists in the DSO.

- Another issue here is: The clients require us to send a SINGLE file. Hence we need a way of appending the Data from multiple InfoProviders to a single file.

Our Proposed Solution:

- Read from underlying DSOs. and store in a intermediate Write - Optimized DSO.

- Perfrom manual aggregation by using ABAP.

- Send delta values to OHD filtering out the before image(ORecordMode = 'X')

Issues:

Need to perform manual aggregation which may be an issue because the volume can be large.(Currently we can not predict the volume.)

Plus Any other issues that you can foresee?

anindya_bose
Active Contributor
0 Kudos

Ok..tell me one thing when you run a query against this cube what value you see for this GL account?

It's 200 only.. that's the final image for this GL Acc. so you can push your cube data to a Direct Update DSO via APD..

and from that DSO you can process your data to OHD.

Regards

Anindya

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I think you should compress the info cube and do the zero elimination. This would ensure that all KF's with same dimension keys are compressed and you would have single record / characteristic combination.

Let me know if it suits you !

Hope that helps.

Regards

Mr Kapadia

*Assigning points is the way to say thanks*

ravi_chandra3
Active Contributor
0 Kudos

Hi

1. No , there is no way to get the after image image delta value from the cube.After Image is the field that is present in the 0RECORDMODE column , and moreover that field is present only in the DSO only. But there is no 0RECORDMODE present in the infocube.So it is not possible to get the After image delta value from the cube.

2.Yes, we can load the data from the cube to the OHD. It's not a difficult task. Can u elaborate on ur requirement.

Thanx & Regards,

RaviChandra