https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/485075#M10866 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/220657">@ANVEKSHA</a>,</P> <P>&nbsp;</P> <P>You should be able to create a "star schema" using CAS Views: <A href="https://go.documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=caspg&amp;docsetTarget=cas-table-view.htm&amp;locale=en" target="_self">SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation / SAS Viya System Programming Guide / view Action</A></P> Wed, 08 Aug 2018 11:05:10 GMT alexal 2018-08-08T11:05:10Z https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/485055#M10864 <P>How do i create a star schema in sas viya which is in cas server. Currently Iam using the 14 days trial version of sas viya.</P> Wed, 08 Aug 2018 09:16:15 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/485055#M10864 ANVEKSHA 2018-08-08T09:16:15Z https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/485075#M10866 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/220657">@ANVEKSHA</a>,</P> <P>&nbsp;</P> <P>You should be able to create a "star schema" using CAS Views: <A href="https://go.documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=caspg&amp;docsetTarget=cas-table-view.htm&amp;locale=en" target="_self">SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation / SAS Viya System Programming Guide / view Action</A></P> Wed, 08 Aug 2018 11:05:10 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/485075#M10866 alexal 2018-08-08T11:05:10Z https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/623467#M13481 <P>Hi Anveksha,</P> <P>You can create a star schema with a proc cas table.view cas action, just as described in&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SAS-Viya-3-5/ta-p/622970" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SAS-Viya-3-5/ta-p/622970</A></P> <P>or&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/Automatic-Data-Loading-with-a-CAS-Data-Source-Star-Schema-in/ta-p/623458" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/Automatic-Data-Loading-with-a-CAS-Data-Source-Star-Schema-in/ta-p/623458</A></P> Mon, 10 Feb 2020 00:52:38 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/star-schema-in-sas-viya/m-p/623467#M13481 Bogdan_Teleuca 2020-02-10T00:52:38Z