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

Register | Login 

 
Lead By Knowing (Opens a new window)  

General Notice: No events within the next 45 days.

Union Vs merge dimensions at report level


 
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
anushajq
Forum Associate
Forum Associate



Joined: 21 Feb 2005

Posts: 919



PostPosted: Thu Apr 30, 2009 6:51 am 
Post subject: Union Vs merge dimensions at report level

Hi,

The Union, intersect, minus functionality is not available in Interactive viewer and we use interactive viewer. Since users want to create it ( it is not possible to do it in the universe), What are my options?

Is merge dimensions (report linking) an option? Is merge the same as full outer join and similar to a Union? Can a merge be converted into a left or right outer join?
How can use merge dimensions to do intersect queries?

What can I do to mimic minus queries since this is not available in interactive viewer? User wants to do it at the report level hence universe level changes are not possible.

Since subquery is not available can I do an inlist?


banghead.gif
ajq
Back to top
Namlemez
Principal Member
Principal Member



Joined: 14 Mar 2005

Posts: 312


flag
PostPosted: Mon May 04, 2009 12:53 pm 
Post subject: Re: Union Vs merge dimensions at report level

JOIN and UNION are not logically the same thing.

I would say your options are:

A. Get users training on Rich Client or Java client icon_smile.gif
B. If there are only a certain number of union combinations they need, have someone with the full client access create template reports and let users play with those.
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.0507 seconds using 17 queries. (SQL 0.0107 Parse 0.0335 Other 0.0064)
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