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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

SUM problem.


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



Joined: 06 Jan 2010

Posts: 41



PostPosted: Fri Dec 03, 2010 12:19 pm 
Post subject: SUM problem.

I have two measures. Sales and Sales1 are the same measures but SALES in the universe have a SUM in the select statement and use SUM in the measure properties, SALES1 only use the SUM function in the object properties.
When a create a reporte in webi, for examples November sales the result is different.

MONTH | SALES | SALES1
Nov. 38,669,449 38,668,415

The SALES result is the correct. My question is why i have to put SUM in the select statement?? I think that with just select SUM function in the object properties is enough.

Thanks.
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Fri Dec 03, 2010 12:21 pm 
Post subject: Re: SUM problem.

You need both, else you end up with measures in the "GROUP BY" clause which causes the number to be too low.

I wrote up a blog post about this very subject not too long ago, you might find it useful.

SQL Aggregate Versus Universe Projection

_________________
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
adlihs
Senior Member
Senior Member



Joined: 06 Jan 2010

Posts: 41



PostPosted: Fri Dec 03, 2010 12:47 pm 
Post subject: Re: SUM problem.

WOW man... You are amazing jajaja... Thanks a lot....
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.0277 seconds using 18 queries. (SQL 0.0028 Parse 0.0008 Other 0.0241)
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