@JuanS_OCS Thank you for your post. I'm trying the alternative to Stored Processes that you mentioned in SAS Viya 3.4. Here is my situation, I have a very big dataset which contains over 200 millions  rows, it has all the detail data which user can drill down from a high level. The problem is loading all the data into my memory is too big.. So I'm trying to use SAS Job execution web application to implement a real-time select statement to my Hive database to fetch the detail data when users clicks drill down. I don't find any people asking question on internet about SAS Job execution web application, and I don't see the part that I want to implement from the user guide neither. Could you please provide me a example on how to implement this? I assume not many people have implemented similar kind of function using SAS Job execution web application?. Thank you very much ... View more

@alexal  my dataset is around 60G, my RAM is only 30G, and we don't have budget to upgrade RAM at the moment, that's why I' seeking alternative solution ... View more

Thanks very much for your reply @alexal  If that's the case, what should I do if my report dataset is too big then? Is increasing the memory the only solution? Does this also mean the report/dashboard can't have up-to-date live data?  In Power BI, you can create a direct query to fetch report data directly from backend database so you can see up-to-date data at the front end report, How do I implement this in SAS Viya though? This functionality seems very common to me .   Also another question is : can dashboards build based on CAS table( *.sashdat file)? Thank you ... View more