Data model for Sas Viya report

[jejobo2340]

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.

[LinusH]

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-SA...

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.