Traditional web-based reporting with SAS BI tools

To Kimball or not - Stars

Reply
Super Contributor
Posts: 356

To Kimball or not - Stars

Hi.

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.

Cheers

Barry

Esteemed Advisor
Posts: 5,198

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
  • 446 views
  • 3 likes
  • 3 in conversation