Monthly Archives: May 2009

Liquid browsing

Last week I had the opportunity to talk with Peter Leweke from Liquiverse about their new data browser and their focus to turn data from lists into a meaning or as they say on their homepage "Life beyond lists". It’s … Continue reading

Posted in Allgemein | 1 Comment

Accessing duplicate members in dimensions

In the last post we had an issue with multiple members sharing the same name but with different key attributes. Every approach of addressing such members with MDX like [Dimension].[Hierarchy].[Name] or [Dimension].[Hierarchy].&[Key] fails because this fetches only one particular member … Continue reading

Posted in Allgemein | Leave a comment

Parent-child dimensions, historical values (SCD) and keys

Usually working with historical values in an SSAS cube is not really complicated. Think of a customer whose ZIP code changed over time which is modeled as a slowly changing dimension of type 2: ID Customer ZIP Current 1 John … Continue reading

Posted in Allgemein | Leave a comment