GeekInterview.com
Series: Subject: Topic:
Question: 135 of 394

Using multiple queries in Webi

Can we combine the results from multiple universes/queries in the same block (table/crosstab/chart) in the webi report ?
Asked by: sreya_1234 | Member Since Nov-2007 | Asked on: Feb 6th, 2008

View all questions by sreya_1234   View all answers by sreya_1234

Showing Answers 1 - 2 of 2 Answers
Girish Sabbi

Answered On : Feb 20th, 2008

View all answers by Girish Sabbi

You can use multiple queries in Webi same as in Deski. You can do so, by creating Query 1 from the first source (universe). Go to the Query Panel and click on add Queries. This would ask you whether you wanna create your second query on the same universe or on another universe.After building the two queries, you would go the Edit report and Merge the dimensions which are common.And you can pull the data from the two queries into a single table.

Yes  2 Users have rated as useful.
  
Login to rate this answer.

Fisrt answer solves your most queries but one thing I would like to mention is you will be only able to pull all the dimensions from one query plus measures from both queries and merged dimensions but what about dimensions from second query which are not merged with any dimension of first query. One workaround is you can change those dimension of second query to Detail object type and pull them in the table, this will give you complete set. 

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.