Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question