Data model for Sas Viya report

jejobo2340 — Tue, 30 Nov 2021 10:21:30 GMT

Suppose you have 11 tables that you want to put them together to create a data model like the one below:

My idea is to create a dynamic model that the expert end-user decides which columns need to be together in the presentation.

For instance, one user needs to put together a product from the orders table with a discount in a table while another user may need to have an employee's full name with a description in the category table.

How can I do it in a report in Sas Viya? Do I really need to join all of the tables into one giant table?

I am coming from Qlik world so I like to compare it with reporting in Sas viya.

Re: Data model for Sas Viya report

LinusH — Tue, 30 Nov 2021 12:36:26 GMT

You should be able to define your model as a star schema:

https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SAS-Viya-3-5/ta-p/622970

A quick look at you model - it look likes it's not a "clean" star schema though. It seems that Budget and EmpOff not really ties to the Orders table, or?

Also, I'm not sure if snowflaking is supported, but denormalizing dimensions shouldn't be a big problem I hope.

topic Re: Data model for Sas Viya report in SAS Viya

Data model for Sas Viya report

Re: Data model for Sas Viya report