I want to build a kind of DWH for tables that form the basis for a large variety of VA reports. These tables will have, e.g. all bills, all members, all providers, etc. Based on the reports I will define filters for the bits of data that I need. Often, I will want to combine information from different tables (e.g. total of bills from all members in a given city). I am wondering what the best way to so is. In particular:
- If I create a star schema or other query in the data builder, my impression is that a new table in memory is created. This practically multiplies the size of the bills table (the biggest I have) with the number of reports I want to base o it (for all different combinations of data). Is there a way to have a kind of 'view', i.e. a data query that doesn't result in a table in memory (but, of course metadata does get created), but only when it gets called (at the moment of the creation of a report) and then doesn't exist anymore once the visualisation is made?
- If I create one big mastertable, it means that all data of a given member or provider is repeated on all lines. I think there is no way around that if I want one data source?
- If I have the separate tables for bills, members and providers, it means that I cannot combine the city of a member with the amount on a bill, without a data query, right?
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.