Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

The results of data queries as a "view"

Reply
Occasional Contributor
Posts: 13

The results of data queries as a "view"

Hi all,

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?

All input will be very helpful!

Cheers, Marcel

Occasional Contributor
Posts: 13

Re: The results of data queries as a "view"

Posted in reply to MarcelHaas

It seems now that it is best to use Star Schemas. The only annoyabnce could be that between fact tables and dimension tables one can only use one linking variable, not a combination.

Ask a Question
Discussion stats
  • 1 reply
  • 319 views
  • 0 likes
  • 1 in conversation