Forum Discussion

Aslan-R's avatar
Aslan-R
Frequent Visitor
8 years ago
Solved

Hana Calculation view hierarchy not Visible

Hi Team,   We are using SAP Hana Calculation view as a source and it has a hierarchy available in it, but that is not visible in PowerBI even when I try to connect it as a cube in Direct Query.(I.e...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Aslan-R,

    Please check if you hit the following limitation.

    1. Parent Child Hierarchies - Parent child hierarchies will not be visible in Power BI. 

    2.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.

    Reference:
    https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Aslan-R,

Please check if you hit the following limitation.

1. Parent Child Hierarchies - Parent child hierarchies will not be visible in Power BI. 

2.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.

Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana

Regards,
Lydia

Aslan-R's avatar
Aslan-R
Frequent Visitor
8 years ago

Hi Lydia,

 

Thanks for your response, I believe our's is Parent-Child Hierarchy and hence it is not getting displayed.

I will try other options and then see.

 

Thank You,

Aslan.