In my past blogs I showed how to use SSIS package to process dimensions, cubes or build aggregates. I am slowly rebuilding my existing packages thanks to points from Darren Gosbell and Jess Orosz. I found that using CaptureXML method is more convenient for me and it is definitely faster.
Read the rest of this entry »
Posted in SSAS, SSIS | 43 Comments »
Recently I posted a blog entry on how to process all dimensions in a single Analysis Services 2005 database using SQL Server Integration Services (SSIS) package. Here I’ll add code to this package that will allow you to process whole database, cubes, measure groups or partitions.
Posted in SSAS, SSIS | 33 Comments »
Years ago, while I was using Analysis Services 2000, I had a strange problem. I migrated one of the cubes to be loaded from a SQL Server View instead of the actual table, and I noticed that the cube size almost doubled. It took me some time to find what was causing this. My original table had a few dozens fields with type decimal(19, 2). They were loaded into analysis services database with type double. After I migrated my fact table into this view, I also migrated some calculations. Read the rest of this entry »
Posted in SSAS | Comments Off on Numbers scale impact on SSAS 2005 storage
After I published blog entry about a SSIS package that processes dimensions, I received a suggestion from Darren Gosbell (his blog is here) that instead of building XMLA code by concatenating strings, I should use the CaptureXML option from an SSAS server object and then process dimensions using dim.Process method and execute XMLA using ExecuteCaptureLog routine.
Posted in SSAS, SSIS | 23 Comments »
Vidas: My next blog entry contains updated code !
It is quite often that I have to process all the dimensions in a database. I like to use scripts for that. Here I have step by step guide on how to create an SSIS package that processes all dimensions in one database.
Posted in SSAS, SSIS | 1 Comment »
With SQL Server SP2, Microsoft added an Aggregation Manager utility to its samples. It is not installed by default, and has to be downloaded separately from http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en, file SqlServerSamples.msi
This utility allows you to see existing aggregates, and allows you to easily add aggregates manually or from a Query log. Do not miss this one!
Posted in SSAS | Comments Off on Aggregation Manager Utility in SP2
I prefer to use usage statistics to generate SSAS 2005 aggregates, but during the initial phases of a project they are not available. So I usually build a set of random aggregates, and after enough usage statistics are accumulated, I rebuild aggregates based on usage. Microsoft provides a nice wizard to generate aggregates on measure groups and partitions. But because I have to do this task way to many times, I decided to build a simple SSIS package that does it for me.
Posted in SSAS, SSIS | 8 Comments »
RSS Feed