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

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Hi There: How to combine queries from 2 universes ??


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
pw201121
Forum Member
Forum Member



Joined: 14 Feb 2011

Posts: 3



PostPosted: Mon Feb 14, 2011 5:11 pm 
Post subject: Hi There: How to combine queries from 2 universes ??

1). could you please shed some light as to how to combine 2 queries from 2 universes ? please be very specific about steps.

2). if there is incompatible objects, will the problem prevent the combining of the 2 universes ?

Thanks much in advance. Appreciate it.
Back to top
BO_Chief
Forum Fanatic
Forum Fanatic



Joined: 06 Jun 2004
ASUG Icon
Posts: 5536
Location: Somewhere on God's Land.


flag
PostPosted: Mon Feb 14, 2011 9:46 pm 
Post subject: Re: Hi There: How to combine queries from 2 universes ??

After generating two data providers one from each universe, you need to merge on common dimensions (aka merged dimensions). Bring the data in one block based on Linked dimension object(s).
_________________
help us help you! make sure your post has the following elements:
Does it include BO version, Database, an error, a problem, a SQL for object or Condition ?
Does it include some sample data what you have?
Does it include any code you already tried ? (working or not..)
Did you explain what you want for results?
If any of those elements are missing,chances are you didn't post enough information for us to help you!
Back to top
Prashant Purohit
Forum Enthusiast
Forum Enthusiast



Joined: 18 Feb 2009

Posts: 1037
Location: Pune


flag
PostPosted: Tue Feb 15, 2011 2:29 am 
Post subject: Re: Hi There: How to combine queries from 2 universes ??

Welcome to Bicon_mrgreen.gifB!!!

Go through below topics to learn more about merged dimensions.

http://www.dagira.com/2009/08/25/what-are-unbalanced-data-providers-and-why-should-i-care/

http://www.dagira.com/2010/06/19/what-does-extend-merged-dimensions-really-do/

_________________
Thanks & Regards,
Prashant

"You cannot believe in God until you believe in yourself" - Swami Vivekanand
Back to top
pw201121
Forum Member
Forum Member



Joined: 14 Feb 2011

Posts: 3



PostPosted: Tue Feb 15, 2011 8:46 am 
Post subject: Re: Hi There: How to combine queries from 2 universes ??

thanks so much for the info, but if there is incompatible object error, do you think the merge would still work ? thanks in advance.
Back to top
pw201121
Forum Member
Forum Member



Joined: 14 Feb 2011

Posts: 3



PostPosted: Tue Feb 15, 2011 8:47 am 
Post subject: Re: Hi There: How to combine queries from 2 universes ??

thanks for the useful info. appreciate it. how about from 2 different universes ? thanks
Back to top
crystalrepxi
Principal Member
Principal Member



Joined: 02 Sep 2010

Posts: 101



PostPosted: Tue Feb 15, 2011 8:59 am 
Post subject: Re: Hi There: How to combine queries from 2 universes ??

Hi

As said above the process is same you have to megred dimensions of
similar datatypes or similar dimensions if exist from two universes.

Thx
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  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.0482 seconds using 17 queries. (SQL 0.0028 Parse 0.0346 Other 0.0108)
CCBot/2.0 (http://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