look up query
i have 2 queries. one has all customers info and another has manager info and list of customer belonging into. both are using diferent cubes
now i want to get customer from first cube and then his manager if any in another cube and display in cube . i am not allowed to have multi cube..
is there any way to achieve this?
query1: customer a
query 2: manager 1 --customer a
final query: customer a , manager 1
please do help me
craete an infoset on two cube...have an ineer join on customer. (Costomer should be nav attribute of manager). Create your query on the infoset. You will get what you are looking for.