https://communities.sas.com/t5/SAS-Visual-Analytics/Dimensional-Model-considerations-for-SAS-VA/m-p/402050#M8284 <P>Is there anything I should be designing into a dimensional model specifically&nbsp;for SAS VA? For example star or snowflake schema?</P><P>&nbsp;</P><P>I heard it extracts all the data from the database and loads it as a flat table - is this right?&nbsp;</P> Sat, 07 Oct 2017 09:08:28 GMT amorts 2017-10-07T09:08:28Z https://communities.sas.com/t5/SAS-Visual-Analytics/Dimensional-Model-considerations-for-SAS-VA/m-p/402050#M8284 <P>Is there anything I should be designing into a dimensional model specifically&nbsp;for SAS VA? For example star or snowflake schema?</P><P>&nbsp;</P><P>I heard it extracts all the data from the database and loads it as a flat table - is this right?&nbsp;</P> Sat, 07 Oct 2017 09:08:28 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Dimensional-Model-considerations-for-SAS-VA/m-p/402050#M8284 amorts 2017-10-07T09:08:28Z https://communities.sas.com/t5/SAS-Visual-Analytics/Dimensional-Model-considerations-for-SAS-VA/m-p/402135#M8286 <P>Flat tables are by far the most common data model for SAS VA. Star schemas can be used but personally I've never found a need to use them so far. The main reason for using a star schema is to reduce storage requirements, with the downside of greater complexity.</P> <P>&nbsp;</P> <P>However you can also reduce storage requirements for flat tables by combining the use of short character codes and user-defined lookup formats. In effect you are applying the star schema lookup capability without the complexity by using lookup formats.&nbsp;&nbsp;</P> Sun, 08 Oct 2017 01:41:00 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Dimensional-Model-considerations-for-SAS-VA/m-p/402135#M8286 SASKiwi 2017-10-08T01:41:00Z