look up query

[Former Member]

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

[Former Member · Accepted solution]

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.

Thanks,...

Shambhu

[Former Member]

Well .. I guess that you have good reason to not use multiprovider, but, since this is THE solution for your problem ... I don't see any good way to do so without a MP. Maybe an infoset ?

You can also insert 2 queries int one workbook, with both sheets hidden, and rebuild the query result by the way of VBa, using VLOOKUP-like functions.