Urgent! Hierarchy Nodes Missing in Queries

[Former Member]

Hi,

For cost center hierarchy, some nodes r missing in the Query. I checked in the cost center hierarchy tab page. i could see all the nodes in 0Costcenter and as well as in source system. How can i get all the hierarchies nodes. what exactly the problem. why some nodes r missing.

please respond me immediately if any body faced with same kind of problem.

Nagesh.

Message was edited by: Nagesh Ganisetti

Message was edited by: Nagesh Ganisetti

[Former Member · Accepted solution]

Hi,

This happens when there is no data for the missing nodes..

Make sure that you have data for all the nodes..The nodes which donot have any transaction data in the infoprovider will not show up..

Ashish...

[Former Member · Accepted solution]

Hi Ashish,

r u sure? if no there is no Transactional Data then it won't appear on the Output?. Please check once again and confirm for me. How can i know whether Transactional data available r not?

Thank you.

Nagesh.

[Former Member · Accepted solution]

Hi Nagesh,

I am sure ..

Go to the list cube transaction and check for one of the missing nodes and see if you find any data in the cube..

Eg: If your hierarchy has node for country and one of the nodes you are expecting to see is US ..but cannot see it in the query ..see if you have any data for US in the info provider..

Ashish..

[Former Member · Accepted solution]

could u please confirm any body... Hierarchy node will be displayed only when relevant Transactional data si available?

for my costcenter hierarchy, Somes nodes r missing.

plz guide me.

Nagesh

Message was edited by: Nagesh Ganisetti

[Former Member · Accepted solution]

Hi Ashish,

I'm really very sorry. I miss understand your words. Any way wht ever u told is correct. I'm assigning points to you.

Nagesh.

[Former Member · Accepted solution]

Good that it solved your problem..

Ashish..