Skip to Content
author's profile photo Former Member
Former Member

Errors in heirarchy

Hi every1,

I am having problem creating query for my infocube.i have a heirarchy also.These are my feilds...Cust id,Mat id,sales rep id,sales revenue,price of material..i have a conversion routine for sales revenue..

In my query when i rt. clicked and selected properties i assigned the heirarchy and did "ok" but when i try to run it i see nothing only the column names. and there is one saying unassigned nodes which if i clcik further has some values..but what happened to my heirarchy and it's nodes.?any help..



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 05:18 AM


    This happens when for the values in your hierarchy there are no orresponding values in the transaction data (in Cube). For example if have a country "India" in your hierarchy but no data for India exists in Cube then in your report it gets asigned to Unasigned node.

    Hope I have made things clear.

    Another thing to check is whether your hierarchy is correct. Goto the hierarchy in RSA1 and open and check.



    (Do not forget to assign points.)

    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.