SAS VA How to work with Star Schema

[DartRodrigo]

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 

[LinusH]

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

[DartRodrigo]

Thanks @LinusH

Is there any tutorial to setup this ?

Thanks in Advance

[LinusH]

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%2F...