Traditional web-based reporting with SAS BI tools

To Kimball or not - Stars

Super Contributor
Posts: 356

To Kimball or not - Stars


So We have been proposed a Dimensional modeled Data Warehouse, and I was wondering if anyone is using SAS WRS to access Star schema's and what the perfomance was like, and any tips and tricks were out there to handle this.



Super User
Posts: 5,391

To Kimball or not - Stars

It's very hard to give general suggestion on optimization. But nevertheless, I'll try.

The Base and SPDE engines gives reasonable performance, even if they do not offer specific star schema optimization. SPD Server and other 3rd party databases do.

Historically, by placing an information map on top of a star schema really downgraded performance. In later versions they have improved - you need to test on your data to make sure if it will work for you.

Star schemes a very good as input to OLAP cubes. They offer when well configured very good performance, and can be accessed directly by WRS.

Good luck!

Data never sleeps
Occasional Contributor
Posts: 6

Re: To Kimball or not - Stars

If you use MS SQL Server for your data storage you could try experimenting using Column Store Indexes in SQL Server 2012...

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation