- In dashboard we have interaction, bar charts and table. The table is in lasr  has 160 million record and 30 column. Out of 30 column 24 columns are character and 6 columns are numeric. 24 column also includes user name (lets assume tom, sam etc). Lets assume out of 160 million, 4000 records are of SAM, 10000 records are of tom. - Sam login from web portal and will see dashboard that he is suppose to see based on access set in above table. Interaction, charts response time is fast but to display 4000 records in table in dashboard is taking a long time.  The dashboard will be accessed concurrently by many users and is dynamic ( Today SAM has 4000 records after 2 days SAM may have 3500 records) - How to we increase the the response time of displaying table in dashboard? We tried reducing the length of character column but didn't helped much. Any other approach that can be tried to increase response time of displaying table in dashboard? ... View more

Hi We are working on a project which has SAS VA (7.1) distributed architecture using hadoop. The stack also has SAS DI. My understanding is all data processing, transformation, detailed table creation should happen in SAS DI and is recommended approach. The data is then loaded in LASR server which is consumed by dashboard developer. Another approach is do the processing, transformation, detailed table creation in SAS VA data builder and load in LASR server. So most of the DI jobs would be done in SAS VA data builder. Queries - 1. Which approach is recommended and what are the pros and cons. 2. Can DI jobs be created in SAS VA data builder. Is yes are there additional procs that needs to be used specific to hadoop Regards so ... View more