Team Name OTSI Track Industry- Public Sector Use Case Water management using ML & Optimization techniques to overcome the water scarcity. Prediction of water availability/scarcity in various regions/zones/area and suggesting on the nearest optimal water resource from where water can be replenished. Technology SAS Viya - VDMML, VA, Data Preparation, Model Studio Region AP Team lead Abhishek Pathak Team members @avvy  @Bhargav_P  @rayuduadabala  @Atchut  @Gogulamudi  @MuralaVenu  @ManojPappula @Justus14        ... View more

Dear Users,   I have a business scenario, where I will have to process lot of tables from source storage (files are in form of CSV) for standardization i.e. Demographic standardization etc. The DQ job has to understand the Columns and then pick the column which has demographic values (identification) and further standardize those columns.     The challenge are as below: 1. The job has to identify the number of files in the folder location to be processed and the file names 2. The job has to identify what columns are there in individual tables and which columns refer to demographic values 3. Standardize the identified columns 4. Loop the entire process.   The major challenge is that all the files in the source can have any number of columns and can consist of different columns as compared to the previous or next file in the source folder.   Any ideas on this will really be helpful.   Thanks & Regards, Abhishek Pathak   ... View more

Dear Readers,   I want to mask the VA URL for Public Access i.e. Somebody puts the VA url link as VA.XXXX.com. this URL should redirect to my VA server but internally the URL for VA will be like SASVA.xxxx.co.in:7980/SASVisualAnalyticsHub. The internal VA link on which VA server is configured should not be visible to end user along with the port at which it is running.   Can somebody let me know how can we achieve it or any idea would be of great help.   Thanks & regards, Abhishek ... View more

Hi All,   I have created a report link (URL) for one of my report which has to be integrated in one of the website. Now, I am able to access the reports without the credentials(guest access) by clicking the link (URL). But the only issue which I am facing is that the report does have the option like "Browse", "Print", "Email" etc availiable in the VA banner which should not be availiable. Is there any way that we can disable these options?   I can understand that we can remove the SAS VA banner itself by passing the parameter "reportViewOnly=true" in the URL but it also removes the "back link" when I click an image in the home screen to visit particular section of the report ( section links are given on images in the report) and then I dont have any way to return back to the same (home) page.     Kindly help me on this.   Thanks & Regards, Abhishek Pathak     ... View more