on 07-17-2018 2:27 PM
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.
Are HANA hierarchies supported yet?
Thanks and best regards
Frank
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Regards,
Julian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Regards,
Julian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.