Skip to Content

- Hierarchy structure not shown up in the report

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 05, 2007 at 12:22 PM

    Try using different queries in place of views.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.