Sunday, June 17, 2007

Exploring Katmai part 2 (SSAS)

First up in my explorations is new features of Analysis Services in Katmai..

Attribute Relationships

A new feature when designing dimensions is a new tab "Attribute relationships", which visualizes the relationships between attributes. That is, you will be able to see the hierarchies in a visual manner and how they interact with each other.

The example below is a visualization of the attribute relationships of the product dimension.



From within the Attribute Relationships it is possible to create new relationships. A new dialog will popup, which looks like this:



New Key Columns Dialog Box
When designing the keys of the dimensions a new dialog box is available - nothing much really. It looks like this



Another new feature when talking dimensional key design is, that it is now possible to change the key in the properties window without opening up any windows/wizards..

Backup and restore
Another thing is that backup and restore has undergone some structural changes which should give a performance gain, however I haven't tested this...

So what's the verdict?
So for the matter of Analysis Services nothing much has come through yet. I look forward to seeing other improvements of Analysis Services in future community previews.

0 comments: