Skip to Content

SAP BW: Cube like ADSO still needed?

Hello world,

today I would like to ask the experts the question when do I need to set up a ADSO as a cube? Of course I see the need for inventory or planning stuff.

But, say I want to report on information coming from data source "Actual Cost Line Items (Delta) 0CO_OM_OPA_6.

After activation of an ADSO with key (Document Number & Posting Row (ok, I skip here additional information to keep it simple)) all information is available (means unique and consistent).

In this case I would set up a HCPR and a bex query to report on all the given fields to provide amounts per period, cost element, order, cost center, shoe size, etc..

Or why is there a need to include a ADSO with type CUBE? Back ground of my question is I would like to keep the data model as simple as possible and avoid costly duplication of data.

Thanks your sharing your expertise.

Have a nice week.

Regards,

Dio.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 14, 2019 at 07:25 AM

    Cube-like ADSO will only be useful if you're not able to provide keys. If you can, there will be no need to build one on top of your ADSO. This won't bring any significant performance improvement.

    Note that one of the main goal of LSA++ architecture is to avoid data duplication.

    Regards,

    Frederic

    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.