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.

Merged Dimension data coming from 2 universe


 
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
NidaKhan
Senior Member
Senior Member



Joined: 21 Aug 2012

Posts: 97



PostPosted: Thu Apr 11, 2019 11:11 am 
Post subject: Merged Dimension data coming from 2 universe

Hi can we merge Dimension if we have 2 universe , uni 1 data source is Oracle and uni 2 Data source is DB2 or SQL.
can we still use merge dimension in the report ???

Thanks
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Fri Apr 12, 2019 3:01 am 
Post subject: Re: Merged Dimension data coming from 2 universe

Yes
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
NidaKhan
Senior Member
Senior Member



Joined: 21 Aug 2012

Posts: 97



PostPosted: Fri Apr 12, 2019 3:55 pm 
Post subject: Re: Merged Dimension data coming from 2 universe

well. can you explain how its possible ?
well keeping in mind we are not talking about IDT. Multi data source.
Thank you in advance
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14213
Location: England


flag
PostPosted: Sat Apr 13, 2019 8:59 am 
Post subject: Re: Merged Dimension data coming from 2 universe

Select the two matching dimension, right click, Merge. They must be of the same type.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Mon Apr 15, 2019 2:43 am 
Post subject: Re: Merged Dimension data coming from 2 universe

NidaKhan wrote:
well. can you explain how its possible ?
well keeping in mind we are not talking about IDT. Multi data source.
Thank you in advance


You'd merge in the same way as merging an Excel sheet or text file.

Make sure you're merging date with date, text with text, number with number.

Use the merge functionality within Webi, as per the user guide for your version of Webi. icon_smile.gif

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
NidaKhan
Senior Member
Senior Member



Joined: 21 Aug 2012

Posts: 97



PostPosted: Mon Apr 15, 2019 11:19 am 
Post subject: Re: Merged Dimension data coming from 2 universe

Thanks for the reply.
but here what i think since before BO 4. IDT. we have Single Data source connection. so how it will be the possible to merge dimension based on the universe created from different database. i know we can merge dimension from different data provider. but still not understanding how it possible merge dimension from universe crated from different data base ???
Back to top
NidaKhan
Senior Member
Senior Member



Joined: 21 Aug 2012

Posts: 97



PostPosted: Mon Apr 15, 2019 11:21 am 
Post subject: Re: Merged Dimension data coming from 2 universe

Thanks for the reply.
but here what i think since before BO 4. IDT. we have Single Data source connection. so how it will be the possible to merge dimension based on the universe created from different database. i know we can merge dimension from different data provider. but still not understanding how it possible merge dimension from universe crated from different data base ???
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14213
Location: England


flag
PostPosted: Mon Apr 15, 2019 12:50 pm 
Post subject: Re: Merged Dimension data coming from 2 universe

Just try it? And tell us what does or doesn't happen.
Back to top
Debbie
Forum Addict
Forum Addict



Joined: 01 Mar 2005

Posts: 2765
Location: Cheshire, England


flag
PostPosted: Wed Apr 17, 2019 9:30 am 
Post subject: Re: Merged Dimension data coming from 2 universe

NidaKhan wrote:
Thanks for the reply.
but here what i think since before BO 4. IDT. we have Single Data source connection. so how it will be the possible to merge dimension based on the universe created from different database. i know we can merge dimension from different data provider. but still not understanding how it possible merge dimension from universe crated from different data base ???


Because once you have it in your report, it's just data. Webi doesn't care where it came from.

Debbie
Back to top
GenMath
Senior Member
Senior Member



Joined: 05 Oct 2011

Posts: 99


flag
PostPosted: Thu Apr 18, 2019 7:23 am 
Post subject: Re: Merged Dimension data coming from 2 universe

Because when you're using .unv Universes you do the merging on Webi , while using .unx universes you do the merging using multisource connection option that IDT offers.
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 1 All times are GMT - 5 Hours
 
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.0311 seconds using 17 queries. (SQL 0.0025 Parse 0.0010 Other 0.0277)
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