on 12-19-2016 3:53 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mauro ,
No limit on query in universe and report .
my issue is resolved , i applied join on condition.
Thanks
Raghunath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.