Skip to Content
-1

Report data issue

Hi All,

When I execute report SQL in toad , expected records are fetching related to customer , where as in boxi all records related to customer it is fetching .

When I tried to create derived table , using same SQL expected records we are getting .

Universe is design with four tables , there is no loop …

Any inputs , users are chasing

Thanks,

Raghunath

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 27, 2016 at 03:14 PM

    Hi Rahunath,

    Did you check query limits or the universe? maybe it's retrieving just the first n rows and that's why results are different between BO and Toad.

    let me know please,

    thanks

    Mauro

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03, 2017 at 06:02 AM

    Hi Mauro ,

    No limit on query in universe and report .

    my issue is resolved , i applied join on condition.

    Thanks

    Raghunath

    Add comment
    10|10000 characters needed characters exceeded