Skip to Content
author's profile photo Former Member
Former Member

After image delta from cube to OHD..

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 27, 2011 at 06:10 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Nov 28, 2011 at 01:07 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 11:44 AM

    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*

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.