topic Re: SAS VA How to work with Star Schema in SAS Visual Analytics

SAS VA How to work with Star Schema

DartRodrigo — Wed, 18 May 2016 13:39:09 GMT

Hi mates,

Recently, i've found out that there is the possibilty to work with tables in SAS VA using star schema,

witch is why this could solve loads of problems here.

Star Schema: A star schema consists of a collection of tables that are logically related to each other.

My questions are:

- How can i create a star schema ?

- Is it possible to work with more than one table and correlate them while creating a report ?

- May i create a relationship before create a report to work with more than one table ?

- If yes, Is there anyway to only relate them and use ? I mean not to create a third table ?

Thanks in advance

Re: SAS VA How to work with Star Schema

LinusH — Wed, 18 May 2016 19:40:32 GMT

- The documentation should cover the how's. This subject has also been touched in a few global forum papers.
- Yes, that's the main idea
- Yes, that's the main idea
- Well, definition wise, the relationship of a star schema is kinda virtual. But it materialises during query. So given the input from different sites this works best, at least resource consumption wise, ix you have many smaller star schemas.

Re: SAS VA How to work with Star Schema

DartRodrigo — Wed, 18 May 2016 20:35:30 GMT

Thanks @LinusH

Is there any tutorial to setup this ?

Thanks in Advance

Re: SAS VA How to work with Star Schema

LinusH — Thu, 19 May 2016 06:49:23 GMT

We are glad to help you, but it's annoying when you don't even try to gather this information yourself.

I found this within 5 secs...

https://support.sas.com/cdlsearch?qt=star+schema&Find=Search&qp=url%3A%2Fdocumentation%2Fcdl%2Fen%2Finmsref%2F68736%2FHTML%2Fdefault