April 1, 2011 at 2:54 am
For a client of mine I had set-up an OLAP cube using Office Excel 2003. Very basic yet very powerful in my opinion.
What I had was the following:
A table with all the sales (turnover) for 20 stores, net Margin on the product, products divided over 3 categories and date it was sold on. Every single sale was recorded, so if a customer bought 2 times product A and 5 times product B this would cover 2 lines (records).
In total I have 3 million records (in Access) for one year.
In no time the cube was build with the following dimensions:
Date (month), Store, Category
The following was sumarized:
Sales, Net Margin
With the cube it was fairly easy to build all sorts of Pivots in Excel. Impressive!
Now, my client has Office 2007 and cannot build any cubes anymore.
I had heard about cubes in SQL Server and I tried this hoping to be able to use SQL server for this.
Problem is, that after trying very hard for a while I still cannot build anything like it in SQL Server.
Any Ideas? Tips?
Henk
April 1, 2011 at 3:40 am
download the Adventure Works DW and Cubes from codeplex, this will give you a chance to see how a cube is built, (building a SSAS cube follow the same basic structure as a cube in excel) and also will also allow you to follow the examples in books on line
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply