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