Show all nodes in a hierarchy

[former_member971209]

Hi all,

I am working with a report where I am showing a hierarchy. I am wondering if it is possible to see all nodes in the hierarchy, that is even if some nodes do not contain data. By default only the nodes that contain data are displayed. How do I show all nodes in BI 3.5?

Thanks in advance!

CL

[jaya_mogali · Accepted solution]

Hi CL,

You can try following.

Make sure you have some data in say KF A for the each node even if it is zero in the cube on which you are creating report Add this KF A to your query and Hide the KF. Make sure you do not have any restrictions to this KF A.

I just took example KF A . This can be any of your KF in the cube or a Calculated KF,

Jaya