Merging Dimensions

If I want to use an object from two different classes in one query, what is the procedure to do so...Combined query or merge dimensions?

Questions by Nkakad

Showing Answers 1 - 1 of 1 Answers

uday_bo_09

  • Nov 13th, 2010
 

In webi richclient, create two queries and you have an option called combined query by which you can combine two queries. You can also apply UNION INTERSECTION AND MINUS to these quires and run query to generate report.

Purushottam Vangala

  • Aug 8th, 2011
 

Very simple Merge the Dimensions.

  Was this answer useful?  Yes

Shylaja

  • Nov 3rd, 2011
 

Just apply join condition both table or multiple table

  Was this answer useful?  Yes

krishna

  • Dec 1st, 2011
 

If you are using same dimension from different table like Year dimension will use in all the rate tables.

At that time will Combine(merge) all the dimensions in to one dimension.

  Was this answer useful?  Yes

phani

  • Dec 7th, 2011
 

It is a common dimension there in two queries. The basic use of merge dimension is to create a common block with the help of two or more data providers.
steps: 1. Create a report with two queries.
2. Make sure both the queries must have atlease one common dimension as well as same level of data.
3. Go to merge dimension.
4. If it is not merged, select common dimension from both the queries and click on merge.
6. click on ok.
6. Go to templates--> drag and drop verticle table into structure pane.
7. Go to data ta-->drag and drop common field into structure pane.


I think the above answer will help you out. If not let me know.

Thanks,
Phani

naguakkina

  • May 14th, 2015
 

so, here in this case two different classes within a data provider -- > go with combined query
prerequisite : corresponding number of objects should be same and data types should be same.
if you want do the combine two different classes within multiple data providers --> go with merge dimensions.
prerequisite : should have a common column with same data type

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions