Monthly Archives: November 2006

  Analysis Services 2000 has a tool named the Aggregation Partition Utility (see my post on 10/24/06) which allows a developer to design custom aggregations in addition to whatever aggregations may already exist. So far no similar tool exists for … Continue reading →

Processing objects in parallel is a great advantage and is one of my favorite features of SSAS2005. You could do it in AS2000 using the PPU (Parallel Process Utility), however it was a pain in the behind and had it’s problems. … Continue reading →

When setting up a dimension with a relationship type of Refence you have the option of "materializing" the dimension. Design Relationship screen     According to Microsoft, this is the definition of Materialize: Select to store the attribute member in the intermediate dimension … Continue reading →

In our data warehouse we have several parent child relationships which are updated with every load, or every hour. These relationships also exist in the OLAP environment as PC dimensions and are updated with every warehouse load.   Being that our cubes … Continue reading →

Here are a few examples of Named Sets we use for a date dimension in our cubes. Named sets for dates are a must so the user doesn’t have to reselect a different day every time (for example, they always … Continue reading →

Earlier today I was writing some calculated measures for use in one of our cubes. I was testing them out and they were running fine.   When time came to embed them within XML for use in the cube, upon compiling I … Continue reading →