Skip to Content

SAP Analytics Cloud - Data integration in Hana view models

Hello,

We are working with a live connection to Hana, creating models from Hana calculated views. There is no posible mapping between the dimensions in our views and the dimension types offered by Analytics Cloud. Is there anything we can do to sort this out? It limits our work afterwards because there are some charts we cant build properly without a Time dimension for example. Also we cant indicate ID + Description of one dimension at a time.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 20, 2017 at 04:48 PM

    Hi Florencia Robledo ,

    You are correct, there is currently a limitation on how we handle time dimensions in Live HANA models. The usual drilling that you are able to do in planning and imported models are not available for HANA Live models. I updated the KBA that indicates the limitations using HANA Live connections.

    2400377 - Limitations of HANA Live connections in SAP Analytics Cloud

    Developers are working on this feature as we speak.

    Depending on your needs, you can include year, quarter, month, etc. as a separate dimensions in your HANA Calculation View.

    This blog illustrates how to do it:

    https://blogs.sap.com/2012/04/11/generate-time-data-in-sap-hana-part-2/

    It seems that the part 1 was not migrated correctly from the previous SCN but I hope you get the idea.

    Regards,

    Julian

    Add comment
    10|10000 characters needed characters exceeded