Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

need help with direct query, visualization

I have two sql queries - one that has order no, shipped qty and pending qty and the second sql query has order no and no.of days the order is on hold, i need a visualization that has all information ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Push back all the processing to the source( direct query relies on server performance as well, so make sure its sufficient enough to cater your requirements ), use a stored procedure to calculate in server side or use a view. 

Direct query only to be used when you need real time analytics and large data volume where local RAM cannot handle. Use import mode and see how it goes.

Thanks

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

I have one more question, right now am using a sql code – where am bringing in all the order numbers(the reason why I have about a billion rows), in- direct query – can I customize the sql code? I can use the sql query to one particular order number, but I need to be able to look for all order numbers, instead of going to the advanced editor and changing the order number, is there any other way I can work on this? If so how?