You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

COUNT(DISTINCT ODD RESULTS

Accepted answer
26
Views
2
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 2 comments

Summary

count in SQL DEV different than DV ??

Content

We are tying to validate our reports.  We get different numbers when we run My Calculations "COUNT(DISTINCT VOUCHER_ID)" in DV TILE versus "COUNT(DISTINCT VOUCHER_ID)"Oracle SQL Developer. 

Both use the same SQL (pulled SQL from DV paste into SQL Dev), same ADW. 

I have refreshed the Dataset more than once today.  DV is processing this dataset differently than SQL Dev.  How?  I have lost

count 318 in DV

count 550 in SQL DEV

Version

18 , Cloud
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!