topic Re: Unable to find an option in SAS VIYA to create star schemas in SAS Visual Analytics

Unable to find an option in SAS VIYA to create star schemas

aditi0424 — Thu, 26 Jul 2018 09:58:11 GMT

Hi Experts,

I want to link my tables to create visualizations in SAS VIYA just like the feature in SAS VA(please refer the image above). Just help me with my explorations if this options is yet feasible with the upgraded version i.e, SAS VIYA.

Re: Unable to find an option in SAS VIYA to create star schemas

JuanS_OCS — Thu, 26 Jul 2018 10:05:42 GMT

Hello @aditi0424,

you can in Viya, it is named Views

https://go.documentation.sas.com/?docsetId=caspg&docsetTarget=cas-table-view.htm&docsetVersion=3.3&locale=en

https://blogs.sas.com/content/sgf/2018/07/24/data-views-sas-va/?utm_source=LinkedIn&utm_medium=social-voicestorm&utm_content=2e93791a-7335-49c7-af9e-ce58bb8a07e1

Re: Unable to find an option in SAS VIYA to create star schemas

aditi0424 — Thu, 26 Jul 2018 10:18:12 GMT

Hi @juan$_OCS, So for that I will have to write the code in sas studio after creating a cas connection. Also, just curios to know if there is any GUI option to do the same just like we have in SAS VA as I would need to create my data model prior to creating visualizations.

Re: Unable to find an option in SAS VIYA to create star schemas

JuanS_OCS — Thu, 26 Jul 2018 10:19:31 GMT

Hello @aditi0424,

did you had the chance to read the second link?

Re: Unable to find an option in SAS VIYA to create star schemas

aditi0424 — Thu, 26 Jul 2018 10:28:40 GMT

Hi @JuanS_OCS,

Just checked the second link. Since I am working on trial version of SAS, I could not see the required options there. Attaching the screenshot of the same. Please let me know if I am missing on any component of the trial version.

Thank you so much for your patience and help.