topic Adding new columns to a LASR table in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Adding-new-columns-to-a-LASR-table/m-p/162102#M849 <HTML><HEAD></HEAD><BODY><H4><BR />Scenario</H4><OL><LI>Create a SAS dataset</LI><LI>Load the above SAS dataset into a LASR table</LI><LI>Create a SAS VA <EM>Exploration</EM> off the above LASR table</LI><LI>Create some new custom hierarchies in this <EM>Exploration</EM></LI><LI>Add 5 new columns to the dataset created in step 1 and reload the LASR table</LI><LI>Refresh the data in your <EM>Exploration</EM></LI><LI>The 5 new columns do not appear!</LI></OL><P></P><P>How does one continue to use their <EM>Explorations</EM> while also picking up new columns added to the underlying LASR table?</P><P></P><P>Note* Creating a new <EM>Exploration</EM> does pickup the new columns but then we lose the hierarchies created in Step 4.</P><P></P><P>Sanjeev</P></BODY></HTML> Fri, 26 Sep 2014 18:42:56 GMT Sanjeev 2014-09-26T18:42:56Z Adding new columns to a LASR table https://communities.sas.com/t5/SAS-Visual-Analytics/Adding-new-columns-to-a-LASR-table/m-p/162102#M849 <HTML><HEAD></HEAD><BODY><H4><BR />Scenario</H4><OL><LI>Create a SAS dataset</LI><LI>Load the above SAS dataset into a LASR table</LI><LI>Create a SAS VA <EM>Exploration</EM> off the above LASR table</LI><LI>Create some new custom hierarchies in this <EM>Exploration</EM></LI><LI>Add 5 new columns to the dataset created in step 1 and reload the LASR table</LI><LI>Refresh the data in your <EM>Exploration</EM></LI><LI>The 5 new columns do not appear!</LI></OL><P></P><P>How does one continue to use their <EM>Explorations</EM> while also picking up new columns added to the underlying LASR table?</P><P></P><P>Note* Creating a new <EM>Exploration</EM> does pickup the new columns but then we lose the hierarchies created in Step 4.</P><P></P><P>Sanjeev</P></BODY></HTML> Fri, 26 Sep 2014 18:42:56 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Adding-new-columns-to-a-LASR-table/m-p/162102#M849 Sanjeev 2014-09-26T18:42:56Z Re: Adding new columns to a LASR table https://communities.sas.com/t5/SAS-Visual-Analytics/Adding-new-columns-to-a-LASR-table/m-p/162103#M850 <HTML><HEAD></HEAD><BODY><P>maybe if you first drop the origenal lasr table and recreate it under the same name.</P><P>maybe the import query is stored in the background.</P><P>while using a registered sas table and importing the data via a data querry, its more easy to control.</P><P>Greetings Peter</P></BODY></HTML> Sun, 28 Sep 2014 09:39:55 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Adding-new-columns-to-a-LASR-table/m-p/162103#M850 PeterWijers 2014-09-28T09:39:55Z