Combine OLAP and non OLAP universes

[Former Member]

Gurus,very interesting insight here

I need to confirm the steps here for approach 2

Create 2 queries in a Web Intelligence document and synchronize the data providers in the document: it works for any source. It needs to be done in each document.

steps

1)Create OLAP universe

2)Create non OLAP universe

3)create WEBI document on OLAP universe

4)create WEBI document on non OLAP universe

??? next steps please

thanks

[former_member793810 · Accepted solution]

First of of make sure that you have one common filed in both queries.

Create first Report and and Run it

Create 2nd Report and run it

Now on menu bar you will see icon merge dimension next to variable editor icon

It will give you the overview of both queries.

Here you can join common filed and then click on and there you go.

You can add them at the same report or on different.

Bashir Awan

[Former Member · Accepted solution]

thanks

Create first Report and and Run it - Is this on Relational Universe ?

Create 2nd Report and run it - Is this on OLAP Universe ?

Also it says run the report and per Ingo looks like its client slide,so is this merge temporary cannot be saved ,or can per Bashir can be saved in either of those 2 queries or can be saved as 3rd separate query .

Also it says both should have common fields ,but if one query is from sap and other from non sap how can both be same fields?

example - SAP query may have field 0material while non SAP will have Zmaterlal ,how can we then merge dimensions

Thanks again

[IngoH · Accepted solution]

Create first Report and and Run it - Is this on Relational Universe ?

Create 2nd Report and run it - Is this on OLAP Universe ?

>> It doesn't matter.

Also it says run the report and per Ingo looks like its client slide,so is this merge temporary cannot be saved ,or can per Bashir can be saved in either of those 2 queries or can be saved as 3rd separate query .

>> it saved as part of the report

Also it says both should have common fields ,but if one query is from sap and other from non sap how can both be same fields?

example - SAP query may have field 0material while non SAP will have Zmaterlal ,how can we then merge dimensions

>> you can have common fields in different systems - or ?

I would suggest you look into the product documentation for details.

Ingo

Thanks again

[Former Member · Accepted solution]

Not sure i followed it.

What is the difference between client and server side solution and what is the business scenario for each to be applied?

Thanks

[IngoH · Accepted solution]

Hi,

client side means you combining the data on your client system (your desktop / laptop) and server side means you are using the actual server system / hardware to do so.

Ingo

[Former Member · Accepted solution]

Thanks Ingo ,what is the use case scenario how to know when to use client and when to use server

thanks

[IngoH]

Hi,

combining data in the Web Intelligence client is called "merged dimensions" and you should be able to find the exact steps with that term in the product documentation.

ingo

[Former Member]

Ingo ,thanks can you describe the high level steps though,english verbage

1)Create OLAP universe

2)Create non OLAP universe

3)create WEBI document on OLAP universe

4)create WEBI document on non OLAP universe

Thanks

[Former Member]

Also

When to use Merge Dimensions Vs Data Federator if we have need to merge SAP and non SAP data.

Like what should be the business case??

Thanks

[IngoH]

Hi,

merge dimension will result in a client side combination and Data Federator allows you to do this on the server side via Data Federator but you also need to keep in mind that Data Federator only provides you the relational view on your InfoProvider.

Ingo