on 02-02-2010 1:36 PM
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 ?
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Jack,
you can merge queries from2 Web Intelligence reports or you could use Data Federator to join two cubes.
ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.