Browse by Tags
All Tags » SQL Server » Analysis Services ( RSS)
-
|
I have put Business Intelligence into a number of small businesses and these guys typically have one server set a side for BI, so how do you cram the database and the cubes into one box to get the best performance? SQL Server databases and Analysis Services...
|
-
|
I keep recommending IT Professionals to check out codeplex for the various samples that are on there to make life easier, but I haven’t been on there myself for a couple of weeks (doh!). This site has largely taken the place of the resource kits...
|
-
|
Fact tables should be narrow and deep. If you are recording every debit card transaction for every customer across the fifteen retail banks you own, you end up with 15 million rows a day, so to save space they need to be as thin as possible. ...
|
-
|
One of the limitations of Analysis Services in SQL Server 2000 (AS 2000) was that a member in a dimension could only have 64,000 children, which was removed in SQL Server 2005 (SSAS 2005). So now you can create a customer hierarchy for your 1 million...
|
-
|
Before I joined Microsoft, I was working on a large project to build SQL Server 2005 analysis services cubes from data in Oracle 10g. The fun we had trying to get the data out and setup the servers! Getting the OLEDB drivers and the Oracle...
|
-
|
Continuing my series of posts on upgrade, I thought it might be good to have a look at the business intelligence components of SQL Server, so here’s a simple grid that I have adapted from Scalability Experts for use in the upgrade workshops and...
|
-
|
Excel is the number one business intelligence tool; It fronts Hyperion, Cognos Financial Planning, and of course SQL Server Analysis Services and Performance Point Server Planning. In Office 2007 there is now excel services so that information workers...
|
-
|
One of the many cool things that's already in Analysis Services in SQL Server 2005 (SSAS) is the concept of many to many dimensions. Suppose I have 3 bank accounts and one of those I share with my wife, and on another I am co-signatory for a local charity...
|
-
|
Analysis Services Analysis Services is Microsoft's OLAP solution that is also a part of the SQL Server product pack. With this first introduction session we want to give you an overview of what you can do with Analysis services. We'll show you the complete...
|
-
|
Business Intelligence is one of the key themes in Office 2007. New BI features of Sharepoint and Excel are tightly integrated with SQL Server BI platform. This presentation will provide an overview of the new BI capabilities, architecture of the Office...
|
|
|