Skip to Content

Problem creating Hierarchy in LIVE Connection to HANA?

Hi All,

We have reached a deadlock situation. Any help would be really greatful.

We have a LIVE Connection to HANA Database which we are using as a data source and later created a model out of it..

Now when we open the model pane, we only see the Account tab with the calculated columns but no Dimensions in it.

Because of this we are not able to create any hierarchies as seen in the video tutorials.

Kindly guide on the same.

Regards,

Kiran Shenvi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 24, 2017 at 09:06 PM

    Hi Kiran,

    This is working as designed.

    See these links:

    Planning Models and Analytics Models

    https://uacp2.hana.ondemand.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/96ca7bd4ed8a45849d0e3b3d6b0131fb.html?search=HANA%20views

    Types of Model

    The three types of model available all support different sets of features. In summary these are:

    • Planning-type model: preconfigured with dimensions for Time and Categories, offers support for multi-currency and security features at the level of both model and dimension. When working with a planning model in a story, users with planning privileges can create their own versions of model data, as well as writing data to the model by typing new values, copying and pasting data, and using allocations features.
    • Analytics-type model: unlike the planning model this type does not support categories and does not require a time dimension.
    • Analytics model based on a HANA view: a simple model with a single Account dimension but with access to other dimensions from HANA. Security is inherited from HANA but can be managed further in SAP BusinessObjects Cloud.

    Models Based on HANA Views

    https://uacp2.hana.ondemand.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/c0f921e26c164594aecc26d7f52e4fbc.html?search=HANA%20views

    HTH

    Add comment
    10|10000 characters needed characters exceeded