Friday, September 19, 2008

Steps for generation of a SAS business datawarehouse

Please also be aware of the fact that SAS is very powerful and flexible system and the steps below can be done in many different ways. It is just one way to get the expected results.

- First step will be to read dimensions and populate sample dimensions data
- Then a fact table will be created.
- In the next step we will randomly generate transactions for the fact table with sales data for three years. To generate the numbers we will use SAS random number generators with uniform and random distributions.
- The final tasks will be to validate and extract generated data and feed the reporting application.

No comments: