BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Linking of two Data providers in BO XI Webi Rel 2

Goto page 1, 2  Next
 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
reachsoma
Senior Member
Senior Member



Joined: 27 Apr 2005

Posts: 41
Location: India



PostPosted: Thu Jan 05, 2006 8:02 am 
Post subject: Linking of two Data providers in BO XI Webi Rel 2

Hi All,

I am working on some POC and trying to create a report in the XI Rel 2 Webi using two universe.One universe connection points to Oracle and other to MS Access.

I am able to generate a two separate queries ( Oracle & MS Access) and shown as 2 tables in the two separate tabs of the webi XI rel 2 report.

Want to link these two data providers using the common key using the linking of data providers option.!..but I am not able to see that menu in the XI Rel webi.(i am sure it must be there but I am not able to find it..!).

Say, want to link "dept code" which is there on "Ora Query 1" and "Ms Access Query 2" and combine 2 queries data into one table.

Could any one please help me on this !

Thanks
Soma
Back to top
irene
Senior Member
Senior Member



Joined: 15 Dec 2005

Posts: 40



PostPosted: Thu Jan 05, 2006 11:57 pm 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

click on the 'Merge Dimension' button, usually 4th from the left after 'Show/Hide Filter Pane', etc.
Back to top
reachsoma
Senior Member
Senior Member



Joined: 27 Apr 2005

Posts: 41
Location: India



PostPosted: Fri Jan 06, 2006 3:44 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

Thanks for your information ...now i am able to join the two data providers.

Need one more help. icon_confused.gif. do you know the function name in the webi which is equalent to the "multicube()" in the BO 6.5.

Need to use this function for to show the measure sum split across the each dimension of combined 2 queries block correctly.

Thanks
Soma Sekar
Back to top
ctanner94
Principal Member
Principal Member



Joined: 11 Dec 2002

Posts: 108



PostPosted: Fri Jan 06, 2006 1:42 pm 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

Is this only available in XI release 2? I am using XI Release 1 and do not see that button....

Thanks
Christine
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22138
Location: Dallas, Texas


flag
PostPosted: Fri Jan 06, 2006 2:08 pm 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

ctanner94 wrote:
Is this only available in XI release 2? I am using XI Release 1 and do not see that button....

That's correct.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Anil Kumar
Principal Member
Principal Member



Joined: 19 Apr 2005

Posts: 259


flag
PostPosted: Mon Jan 09, 2006 5:41 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

MultiCube() is not in for XI R2. Can you explain your requirement with Muticube?

Anil
Back to top
reachsoma
Senior Member
Senior Member



Joined: 27 Apr 2005

Posts: 41
Location: India



PostPosted: Tue Jan 10, 2006 4:28 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

I have the following requirement in the Webi XI Rel 2.

There are two data providers in my report, Query_1 from oracle and Query_2 from MS Access.

Query_1 gets the following data:

Dept_Code Dept_Name
======== ========
10 Finance
20 Marketing
30 Purchase
40 R & D


The Query_2 gets the following data:

Dept_Code Total_Salaries
======== ===================

10 1500
20 1800
30 1200
40 0500



If I make a block in the Desk top Report (BO XI Rel 2) by combing this 2 queries by using MutiliCube(Total_Salaries), I will get the following results.

Dept_Code Total_Salaries(in thousands) Dept_Name
======== ============== ===========
10 1500 Finance
20 1800 Marketing
30 1200 Purchase
40 0500 R & D
=============================================
Total : 5000
=============================================


If I try to make a same report in the webi XI Rel 2 , with out using multicube() function ( since it is not there), I get the following results
which is not correct !.


Dept_Code Total_Salaries(in thousands) Dept_Name
======== ============== ===========
10 5000 Finance
20 5000 Marketing
30 5000 Purchase
40 5000 R & D
=============================================
Total : 5000
=============================================


I think you got my requirement, please let me know if you have any solution for this.( refer help on multicube() function in Desktop Int. for more info...... if u needed)



Thanks in Advance
Soma
Back to top
chris_c
Principal Member
Principal Member



Joined: 10 Jan 2006

Posts: 272
Location: Milwaukee WI


flag
PostPosted: Tue Jan 10, 2006 10:51 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

I cannot speak directly to your problem but here is my hunch.

If you have correctly merged the dimensions then you should be in sysnc but the Name dimension may be causing your problem, Try retreiving your dept name (and any other mismatched dimensions) as detail objects of dept code. We used this method in earlier versions and it fixed incompatiblity issues.
Back to top
chris_c
Principal Member
Principal Member



Joined: 10 Jan 2006

Posts: 272
Location: Milwaukee WI


flag
PostPosted: Tue Jan 10, 2006 11:01 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

You may have to conatenate the dept code and name to get it to work
Back to top
filip
Senior Member
Senior Member



Joined: 29 Dec 2005

Posts: 94


flag
PostPosted: Wed Jan 11, 2006 6:10 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

How exactly is it possible to merge dataproviders? I've tried various things (pointing to dimensions in both the results panel or inside a report) but the "merge" button can't be used, it is greyed out... Or is merging an option that has to be granted in the central management console?
Back to top
Anil Kumar
Principal Member
Principal Member



Joined: 19 Apr 2005

Posts: 259


flag
PostPosted: Thu Jan 12, 2006 2:19 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

Hi Soma,
I tried two queries similer to what you are trying on my server. But I am getting the desired results: This is what I tried using beach universe.
Query 1:
City & City ID
Query 2
City ID & number of guests. Whilre running the queries it will automerged on Cirty ID

Create a table using City ID of Query 2, Cirty & Number of guests. I am getting the desired result.

Anil
Back to top
reachsoma
Senior Member
Senior Member



Joined: 27 Apr 2005

Posts: 41
Location: India



PostPosted: Thu Jan 12, 2006 6:40 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

chris_c / Anil


Thanks for all your help..now it is working for me after using the "merge dimensions" option with Dept code.

I have created some details objects for dimesions in 'Query 2' to compatable with 'Query 1' objects and made a report block in webi.

Here to work, I forced to use the "merged dimention" in the report block, other wish it is not allowing to combine the 'Query 1' and 'Query 2' objects in same block.

In my requiremnt, i dont want to add the "merged dimension" in my report block( to get higher level of aggregation).

Can you pls help on this.

Thanks
Soma
Back to top
venira
Principal Member
Principal Member



Joined: 07 Dec 2004

Posts: 362
Location: Tokyo


flag
PostPosted: Thu Mar 02, 2006 3:15 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

Hi everyone,

can anyone tell me if it is possible to link two queries in Webi XI release1?

R
Back to top
filip
Senior Member
Senior Member



Joined: 29 Dec 2005

Posts: 94


flag
PostPosted: Thu Mar 02, 2006 3:17 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

In WebI XI Release 1 it's not possible. It's a new feature since R2...
Back to top
venira
Principal Member
Principal Member



Joined: 07 Dec 2004

Posts: 362
Location: Tokyo


flag
PostPosted: Thu Mar 02, 2006 3:19 am 
Post subject: Re: Linking of two Data providers in BO XI Webi Rel 2

any work around or solution to get rid of this?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0306 seconds using 18 queries. (SQL 0.0031 Parse 0.0010 Other 0.0265)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo