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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Snowflake Warehouse DB and Unions in WEBI issues


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Lbruegging
Forum Member
Forum Member



Joined: 15 Feb 2012

Posts: 7



PostPosted: Thu Mar 14, 2019 11:37 am 
Post subject: Snowflake Warehouse DB and Unions in WEBI issues

When you create a combined query\union in WebI (using snowflake) your combined query does NOT show the union it shows 1 query with 2 results sets (0 and 1). How do we get this to show a union instead?
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6546
Location: Connecticut, USA


flag
PostPosted: Mon Mar 18, 2019 9:21 am 
Post subject: Re: Snowflake Warehouse DB and Unions in WEBI issues

How are you creating the union? If you're hitting the "Combined Query" button in the toolbar, then you should get a union query.
Back to top
Mark P
Forum Devotee
Forum Devotee



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


flag
PostPosted: Mon Apr 08, 2019 5:26 pm 
Post subject: Re: Snowflake Warehouse DB and Unions in WEBI issues

By snowflake do you mean the product or a snowflaked star schema?
_________________
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
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  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.0270 seconds using 17 queries. (SQL 0.0028 Parse 0.0008 Other 0.0233)
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