Skip to Content
Oct 21, 2020 at 08:07 PM

Hierarchy nodes are shown in a flat list instead of a tree list

83 Views Last edit Jun 22, 2021 at 03:10 PM 2 rev

Hi Friends, i am having a strange issue using BW hierarchy in the Story. The Hierarchy works perfectly fine in BW, i mean i am able to drill down by tree node in the BW Query output. The same hierarchy was not able to see in tree node, it displays only as Flat Presentation when you select Set Hierarchy in the Design panel (Rows). Interestingly there is another hierarchy in the same story and i don't have any issue with that. I did checked the BW query properties as mentioned in the OSS#2538782 and i don't see any issue in my query properties.

Eventually we want to build a Donut chart after applying filters to the Hierarchy by Node level. I did make sure to have the same input parameters in both BW Query and SAC Input prompts and still have the issue.

Appreciate your Help in advance!.