cancel
Showing results for 
Search instead for 
Did you mean: 

BW OLAP- Webi Reports

Former Member
0 Kudos

Hi Experts,

I heard we can't have OLAP linked Universes.

Is it possible to join 2 Webi reports that are coming from diff OLAP Universes which has a common Dimension.

If so,

What will be constraints that I may face?

Any limitations ?

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Active Contributor
0 Kudos

Hi,

1.The output of merged dimension is a union or Join

eg:-Query1 has Emp1,2

Query2 has Emp1,2,3,4

Than after merging what will be the output

Employee keyfigure Query 1 Keyfigure Query 2

Emp1 XXXX XXX

Emp2 XXXX XXX

Emp3 XXX

Emp4 XXX

2. If I have Variables on those Bex queries.How will it behave after merging.

Eg:-Bex Query1--Webi Report1

Bex Variable1--Emp Responsble

Bex Query2-Webi report2

Bex Variable2-Emp Responsble

Bex Variable3-Doc Number

On top of Webi report1,2 i will create a third report .So,what will happen to variables1,2,3 in Webi report3.

>> Variables - assuming the same technical name - will combine

Will they repeat ?

Former Member
0 Kudos

Thx Ingo

Thx

Answers (1)

Answers (1)

IngoH
Active Contributor
0 Kudos

hi Jack,

you can merge queries from2 Web Intelligence reports or you could use Data Federator to join two cubes.

ingo

Former Member
0 Kudos

Thx for the response.

1.The output of merged dimension is a union or Join

eg:-Query1 has Emp1,2

Query2 has Emp1,2,3,4

Than after merging what will be the output

2. If I have Variables on those Bex queries.How will it behave after merging.

Eg:-Bex Query1--Webi Report1

Bex Variable1--Emp Responsble

Bex Query2-Webi report2

Bex Variable2-Emp Responsble

Bex Variable3-Doc Number

On top of Webi report1,2 i will create a third report .So,what will happen to variables1,2,3 in Webi report3.

Will they repeat ?

How they will behave?

Thanks

Edited by: Jack on Feb 2, 2010 1:10 PM