Hi Experts,
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.?i do have data in my heirarchy.I have done the example from the fufu book.It's like there are 3 regions east,west,midwest and each of them have their offices like atlanta,new york,..etc..and each of these offices have their own sales representative name..