Skip to Content

What's faster: Reporting from DSO or from InfoCube ?

Hi,

whats the ultimate fastests solution:

Reporting from DSO

or

Reporting from InfoCube

???

...same Data ?

Best

Martin

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Posted on Sep 21, 2011 at 08:18 PM

    Of course it is reporting based on cubes. Imagine within DSO you have just flat structure=pure database table. Within cube you have data modeled in star schema=fact table surrounded by its dimensions.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2011 at 08:47 PM

    it will depend on the data volume.

    Huge data volume - Cube will the obvious choice.

    Less data volueme - DSO an be used as well.

    with Cube, you can use BWA as well.

    Regards,

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 01:12 AM

    Hi,

    For a large volume of data which is the case in general, Cube is always a better option than DSO. As Cube provides the aggregated data so reporting is faster. Please go through the link. Your doubts will be cleared.

    Indrashis

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 22, 2011 at 05:29 AM

    Hi,

    If you look initial performance of report performance on DSO it is very fast compared to cube. But as data increases it will be slower. It again depends on data volume that DSO or IC contains.

    If you are creating DSO report see SIDs are generated for better performance.

    IC has many advantages like like compression,aggregates,BIA index etc and so on.With IC on top of DSO you are increasing volume or DB growth but report performance will be much better.

    Thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 05:39 AM

    Hi Martin,

    Its based up on many criteria, Like volume of data .... what kind of report to be evaluated... etc..

    As you aware of the designing technique of data base is Multi Dimension Modelling for data warehousing. And Purpose of cube to have analytical report not operational or details level of report.

    Cube is having multiple dimension and you can do your analysis maximum upto the interaction of 3224 Masterdata.

    In simple, when you want to go for detail level reporting or operational report you can do it in DSO level. It may be faster than cube based up to the volume of the records.

    An analytical report or historical report would be very much faster in cube compare to DSO .

    -


    Thanks

    BVR

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 06:02 AM

    Hi Martin,

    For the same volume and same kind of data, reporting is much faster and also most recommended to be done from cube.

    Regards,

    RahulM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 06:34 AM

    Hi,

    The main difference in Reporting from Info cube and ODS is that InfoCube is meant for Multi-Dimensional reporting while ODS reporting is like 2 dimensional reporting

    Refer the below link for info

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b04a79b4-bbea-2b10-da86-bf0fe933fe34&overridelayout=true

    difference-between-ods--cube-reporting

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2011 at 01:20 PM

    Hi

    sorry,

    -much theory ( it should,...)

    -no facts.

    Of course if i put data aggregated from a dso to a cube than its faster, less datasets more speed.

    ...but cubes pull much more data stored in DIM tables ...

    Thank You

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Martin,

      You're getting a lot of theory and no facts because there is no "ultimate fastest solution" for reporting. There is no right answer to the question. It depends on the type of data and on the type of query.

      The rule of thumb is that for queries that return a small number of lines (definitely 1 lines, maybe up to 10s or 100s) and are restricted to a specific set up keys, a DSO with an index on the query key will give better performance. If you are doing queries with unpredictable filters and drill-downs, or queries that aggregate a large number of records, then a cube will usually give better performance.

      Of course, we could come up with specific cases that would break these rules-of-thumb. So if you want a simple answer you'll need to explain what the dataset and query pattern looks like 😊

      Cheers,

      Ethan

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.