Skip to Content
avatar image
Former Member

HCP/HANA hierarchies in SAP BusinessObjects Cloud (Live connection)

Hello,

we are using live connection between SAP BusinessObjects Cloud and HCP. We defined calculation view in HCP. This view contains some dimensions with hierarchies but we are not able to see the hierarchies in story designer in SAP BusinessObjects Cloud.

Is there some restrictions or specifications about types,definition etc. of hierarchies on the side of HANA views (in HCP)?

The model is based directly on selected view thanks to the live connection to HCP.

Many thnanks!

Ondrej Kloucek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 24, 2016 at 08:34 PM

    Hi Ondrej.

    SAP BusinessObjects Cloud, today, supports Parent-child hierarchies (PCH) defined in the SAP HANA calculation views. Admittedly, the online HELP documentation is not very clear, and our Development team is working on revising the support statement.

    For Table and Viz objects as part of the Canvas, it is possible to leverage PCH defined as part of the Dimension. For Dimensions along the row/column, you can click on the "Filter" icon, to access the list of explicitly available PCH presentations.

    Level-based hierarchies defined in SAP HANA calculation views are not supported. But Development is currently investigating the requirement. No specific timelines yet, but it will be on SAP's planned delivery road map for the near term.

    Eric

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Eric,

      thank you for your perfect response!

      I have already had conf. call with member of you product management team and we find out that parent child hierarchies are able to use (despite the documentation and message from support). So thank you for confirmation.

      Otherwise we are facing issue with correct design of that view in the HANA. But this is our internal issue and we have to spend more time at HANA studio to prepare the view in a correct way - we have very complex data model.

      Thank you very much Eric.

      Best regards,

      Ondrej Kloucek
      Mibcon NDC

  • Jan 09, 2017 at 07:33 PM

    Hello Ondrej.


    Happy New Year to you. Some comments to your questions above.

    Today, SAP BusinessObjects Cloud supports Parent-child hierarchy (PCH) concepts modelled as part of SAP HANA analytical and calculation views. This means that for Story widgets focused on visualization like Charts and Table, it is possible to visualize the PCH, and also interact with the hierarchy (i.e. drill-down in Charts, expand and collapse in Table). The documentation is rather misleading today, and we are planning to update this misinformation in the online Help documentation.

    One final point. For the images you reference:

    - https://s21.postimg.org/jprgslr6v/image.jpg

    - https://s12.postimg.org/6jp6bf50d/image.png

    ...there are some UX inconsistencies in the Chart Builder today. It is certainly possible to access the display presentation of a PCH for a given dimension. However, the Chart Builder does not indicate this consistently between Chart vs Table widget visualizations. We will provide this feedback to UX for improvement in a future release.

    Hope this helps.

    Eric

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Eric,

      thank you for your post.

      Meanwhile we allready finished our project and delivered many reports. It costs us very time and energy but then we lean how to use views with hierarchies correctly and how to handle the data the right way.

      Thanks!

      Ondrej

  • Oct 20, 2016 at 09:49 PM

    Hi Ondrej,

    There is limited support at the moment.

    See this link: Live Data Connection

    under:

    Note

    The following features are not supported for data sources that use live data connections:

    Add comment
    10|10000 characters needed characters exceeded