I am creating a star schema model for operational analytics, trying to use SAS VA - Query Builder, Star Schema functionality.
Specifically, I have a fact table about projects (one row represents one project), but the row contains many dates (10-12 different dates). To connect this fact table with the date dimension (we have a specific fiscal year date dimension), a role-playing capability would be needed. It looks like you can not change the join in SAS VA Query Builder: Star Schema, and you can not create multiple joins from FACT to DIM table. This is not only necessary for the Date Dimension, but also Organization DIM and Location DIM.
In my experience, most SAS VA reporting is done with simple flat tables where dimensions have been de-normalized. The reason for this is better performance. If your data model is complicated like it sounds it is in your case then that would slow down a star schema approach even more. So unless your reporting requirements are quite simple - the more complicated the report the slower it is as well - I wouldn't recommend that approach. Note also data loading star schemas will be slower too.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.