- Hierarchy structure not shown up in the report

[former_member9515]

Hello Colleageues

Have recently enhanced a report with 3-tabs( 3-different views of the same query in BI 3.X). Previously it was with single view.

In all these tabs, am using profitcenter hirearchy along the row and revenues along the columns.

In 1-tab, original view has been used and in report, hierarchy structure found correct

with the view.

In the tabs 2 &3, new columns created in the query and the same have been adjusted in the views. However, here hierarchy structure does not match with the report and view.

Sometimes, in the 2nd view while drilling on the profit center getting errror that "no leaf node exists for this node - Warning" appears. But, this is not true since

a> Same profitcenter is having hierarchy nodes

b>Same profitcenter shows up hierarchy noeds in tab-1.

Please let me know.

Regards,

Ningaraju

[former_member189638]

Try using different queries in place of views.

[former_member9515]

Hi Rakesh

Can not use queires in place of view. Have to use views only. This is the process I need to follow.

Regards,

Ningaraju