Skip to Content

BW design when using SAP BW on HANA

Hi guys,

Just want to ask if the design below is still the "RIGHT" model when you are using SAP BW on HANA?

     DATASOURCE

                |

DSO (WRITE OPTIMIZED)

                |

    DSO (STANDARD)

                |

         INFOCUBE

                |

   MULTIPROVIDER

I think DSO and INFOCUBE is already almost the same in terms performance..So DSO = CUBE..Do we still need the CUBE? I mean, is it still necessary? Or we can design it like this with almost the same performance as above design?

     DATASOURCE

                |

DSO (WRITE OPTIMIZED)

                |

    DSO (STANDARD)

                |

    MULTIPROVIDER



I'm talking above is about the design without using the HANA STUDIO which has the ADVANCED DSO..

Also, what is the "RIGHT" model when we will be including the new providers? Is this correct or do we have other approach? Any links or blogs about this will greatly help..

     DATASOURCE

                |

DSO (WRITE OPTIMIZED)

                |

    ADVANCED DSO

                |

         INFOCUBE

                |

COMPOSITE PROVIDER

We are using SAP BW 7.4 on HANA SP8..

Thank you..

Loed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2015 at 09:11 PM

    Hi, Loed.

    You can check SAP's reference architecture, LSA++, improved with SAP HANA DB. It gives some ideas about how to model with new features (also you can find some docs in SAP help portal: modeling and architecture).

    But yes, within SAP HANA engine all columns are like indexes (HANA uses dictionary encoded columns, so HANA column table is by design a star schema), it can efficiently use filters and do aggregation on compressed data faster, so if DSO is suitable for reporting, it can be used without InfoCube. With advanced DSO you also have a field-based design feature (so you can use fields instead of infoobjects, for example for info (not reporting) attributes like comments etc.).

    With CompositeProvider you also can use an OpenODS view for real-time data and external HANA objects or can include HANA models in it directly, so you potentially have more objects, that can be used for reporting.

    Also check the document in this space regarding new EDW design with HANA, it describes a new vector of DW development.

    Regards,

    Andrey.

    Add comment
    10|10000 characters needed characters exceeded