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.

[Webi 4.x] WebI results don't match totals to the same SQL in Oracle


 
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
gadsden_consulting
Principal Member
Principal Member



Joined: 17 Jun 2015
ASUG Icon
Posts: 214
Location: Baltimore, MD


flag
PostPosted: Tue Nov 05, 2019 8:31 pm 
Post subject: WebI results don't match totals to the same SQL in Oracle

I created a small Universe in IDT (BI 4.2 SP05), and am testing it out. So far so good, except for this issue.

If I copy the SQL from Web Intelligence to Oracle SQL, the results are different, so this perplexes me.

In Web Intelligence I get 38,653 unique records, but when I copy the SQL to Oracle I get 38,962 records. (I doubled checked that the records displayed by WebI are unique, so I'm pretty sure of that number).

In IDT the rows returned parameter is set to 100,000 records.

I even copied the SQL back to WebI as Custom SQL but still got the different answer in WebI vs. Oracle.

Anything else to look at? I'm stumped.

***
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6625
Location: Connecticut, USA


flag
PostPosted: Wed Nov 06, 2019 9:03 am 
Post subject: Re: WebI results don't match totals to the same SQL in Oracl

1) Are you using the same user ID in Oracle and the universe connection?
2) Are you certain that the exact same tables, in the same schemas, are being queried?
3) You said you confirmed the uniqueness of the WebI result, but it smaller than the Oracle result -- did you confirm that the Oracle query includes SELECT DISTICT?
4) Since the results are so close, I would copy both result sets into Excel, then isolate the different rows. That might provide a hint as to the reason for the difference.
Back to top
gadsden_consulting
Principal Member
Principal Member



Joined: 17 Jun 2015
ASUG Icon
Posts: 214
Location: Baltimore, MD


flag
PostPosted: Wed Nov 06, 2019 9:15 am 
Post subject: Re: WebI results don't match totals to the same SQL in Oracl

joepeters,

sorry ... I spoke too quick ... I did not have unique rows ... so WebI works.

Thanks for the tips though!
Back to top
jemstar
Forum Associate
Forum Associate



Joined: 30 Mar 2006

Posts: 903
Location: Dublin , Ireland


flag
PostPosted: Mon Nov 11, 2019 6:25 am 
Post subject: Re: WebI results don't match totals to the same SQL in Oracl

right click on table, format table, Avoid duplicate row aggregation
_________________
James Halligan

Business Objects Contractor

http://www.jemstar.ie/

Available for Contract Work In Ireland (and remote work worldwide)

Expert in Universe Creation directly over Enterprise applications (JDE, BMC Remedy, EBMS, Jira, ArisG, Bespoke, Mercator, RAPID, M3, Movex, Investpro)
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.0296 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0261)
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