cancel
Showing results for 
Search instead for 
Did you mean: 

Report data issue

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member

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

Former Member
0 Kudos

Hi Mauro ,

No limit on query in universe and report .

my issue is resolved , i applied join on condition.

Thanks

Raghunath