cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Hierarchies in Table of SAP Analytics Cloud

frankgutknecht
Participant
0 Kudos

Hello,

I have a live Connection to a Calculation View (HANA Database) from SAC.

The CV has a Time Hierarchy. If i create a table in my Dashboard, there are 2 weird things.

First: one dimension is marked as a hierarchy but it's actually a normal dimension.(see attachment)

Second: the time hierarchy is not visible and the dimensions of the hierarchy are not chosable in the column and line list.

sac1.png

ssac2.png

Are HANA hierarchies supported yet?

Thanks and best regards

Frank

Accepted Solutions (0)

Answers (3)

Answers (3)

frankgutknecht
Participant
0 Kudos

Hi,

we are on two different HANA Versions on Test and Productive. It's little bit tricky to choose the correct hana studio version.

I've just seen that the table in the model of the testsystem is working well.

The Dimension 'Erstellungsmonat' is not marked as a hierarchy.

The Time-Hierarchy is still not visible as a hierarchy, but the dimensions are visible. That's fine for us. So we're gonna update our Productive to a newer HANA Version.

Thanks!

Best Regards

Frank

julian_jimenez
Active Contributor
0 Kudos

Hi Frank,

Your hierarchy seems to be built correctly according to the documentation:

SAP Analytics Cloud - Hana live connection Best Practices

Can you use this hierarchy in charts?

I see that your calculation view is using a star join and you are using HANA studio. Check this KBA to be sure that your HANA studio and HANA platform match:

2375176 - SAP HANA Revisions and Compatible SAP HANA Studio Versions

Also, it's important to know the version of HANA you are using. Some SAC features will require you to use SPS12 revision 122.14 or higher

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be...

Regards,

Julian

julian_jimenez
Active Contributor
0 Kudos

Hi Frank,

Your hierarchy seems to be built correctly according to the documentation:

SAP Analytics Cloud - Hana live connection Best Practices

Can you use this hierarchy in charts?

I see that your calculation view is using a star join and you are using HANA studio. Check this KBA to be sure that your HANA studio and HANA platform match:

2375176 - SAP HANA Revisions and Compatible SAP HANA Studio Versions

Also, it's important to know the version of HANA you are using. Some SAC features will require you to use SPS12 revision 122.14 or higher

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be...

Regards,

Julian