HANA hierarchy import calculation view not showing (parent-child)

[LucasK]

Hi all,

I am trying to connected to a HANA DB via Import and trying to access the parent child hierarchies that I have created in the calculation views.

However, the hierarchy seems not to be recognized in any way. Are there any prerequesites that must be fullfilled in order for the hierarchy to show up? 

I do understand that this is not possible in the direct query mode. However, the documentation I found in multiple outlets says that using import this should work...

I appreciate any help or indication where to find a guide on the implementation.

Thanks a lot!

Lucas

[amitchandak]

@LucasK , Please refer to the limitations - Hana direct query -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-hana

• Parent Child Hierarchies - Parent child hierarchies will not be visible in Power BI. This is because Power BI accesses SAP HANA using the SQL interface, and parent child hierarchies cannot be fully accessed via SQL.
• Other hierarchy metadata - The basic structure of hierarchies is displayed in Power BI, however some hierarchy metadata (such as controlling the behavior of ragged hierarchies) will have no effect. Again, this is due to the limitations imposed by the SQL interface.

You can create hierarchy in power bi

create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[LucasK]

Thanks @amitchandak. Unfortunately this does not answer my question.

As stated above, I am not connected through Direct Query.

However, information on the HANA Connector states that Hierarchies from HANA are supported (e.g. https://www.youtube.com/watch?v=y3se-VEDvqU at 1:18). Can anybody validate this? What are the prerequesites and limitations for importing hierarchies?

Thanks!

[v-kelly-msft]

Hi  @LucasK ,

Check the blog below:

https://mccoy-partners.com/updates/connecting-non-sap-tools-on-sap-hana-and-sap-bw

Best Regards,

Kelly

If I have solved your issue,pls mark my reply as answered!

[LucasK]

Thanks @v-kelly-msft . The Blog also refers to direct connections between HANA and PBI. 

Any chance you are aware of a similar post that shows how (parent-child) hierarchies can be imported using the import mode?

Thanks,

Lucas

[v-kelly-msft]

Hi @LucasK ,

After seaching the documents,it seems that you need to refresh the data when first connect with HANA.

If it doesnt help,pls create a support ticket via below link  and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!