Node expand not working in Hierarchy CDS view consumed in Fiori List Repport

[former_member109557]

Dear Experts,

I am trying to display a team hierarchy in Fiori List Report and the data is supplied through Hierarchy CDS view. The Hierarchy is getting displayed but second level expand of nodes are not working.

Source data in back-end

Dimension View

Hierarchy View

Consumption View

Consumption View Query properly expanding in "Analysis Office"

$metadata of published CDS

Published CDS consumed in Fiori Elements List Report page is not expanding from second level even though it is set as "hierarchyInitialLevel: 5" in consumption view and table type set as "TreeTable" in manifest.json

Even though the hierarchy annotations are properly available and getting displayed properly in "Analysis Office" as well but the same metadata is not getting properly expanded in Fiori List Report. Request your help on this issue.

Regards,

Vivek

[gregorw]

Have you checked if the service returns the missing subnodes to the client?

[former_member109557]

Hi Wolf,

Yes, the service returns all the nodes to the client.

Regards,

Vivek

[former_member705662]

Hello,

I am facing the same issue. Did you found any solution please ?

[former_member640495]

Have you found any solution to this issue?

[Raju]

change local annotations in pick first column of smart tree table as **_NodeID / **_NodeText field so that tree will form

[feliperodrigues]

Hi Vivek,

Usually my first advise is to check if your hierarchy is working fine through RSRT or any other UI interface, since you already tested through Analysis for Office we shouldn't focus in the back-end.

I never used the Tree Table via List Report but I already implemented via smart controls in a mixed application. I would advise you to create a blank UI5 application, implement the Tree Table via Smart Table and check if the output works fine.

If it works in the second scenario it might be a bug from the List Report or some extra configuration missing, at least this way you would be able to identify the differences between both apps.

Hope this information helps.

Cheers,

Felipe

[alan_berkey_wa]

Take a look here:

https://blogs.sap.com/2017/02/21/how-to-consume-a-hierarchy-in-cds-view-analytical-query/

[former_member109557]

Hi Alan,

The query works fine when displayed in "Analysis Office" or "WD Grid embedded" as mentioned in this link (https://blogs.sap.com/2017/02/21/how-to-consume-a-hierarchy-in-cds-view-analytical-query/). But the same is not working when consumed in SAP Fiori Elements - List Report.

Regards,

Vivek