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.
... View more
