Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

COUNT(DISTINCT ODD RESULTS

Received Response
88
Views
2
Comments
Brian666H
Brian666H Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

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:

Answers

  • Philippe Lions-Oracle
    Philippe Lions-Oracle Mod

    Hello Brian,

    can you confirm you have the Physical SQL from the DV query, and not just the report Logical SQL ? Another way to check that :can you confirm that your DV data-source has its data-access set to Live and not Automatic Caching in it's property. You can see that and change it by clicking Inspect on your dataset.

    let us know

    tks

    Philippe

     

  • Brian666H
    Brian666H Rank 6 - Analytics Lead

    It was caching, I guess, I closed the browser and re-opened and it started working.  Crazy!