Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Kalido Universal Information Director now generates Analysis Services cubes

with 2 comments

Here’s the press release from Kalido:
http://www.kalido.com/5a04ea36-c50e-4617-b25d-85ea56a22690/news-and-events-press-center-press-releases-detail.htm

I don’t have any direct experience with Kalido’s products (although I’ve heard good things) but I’d be interested to see the cubes it generates. I wonder to what extent it’s possible to optimise automatically generated cubes?

Written by Chris Webb

July 21, 2008 at 5:04 pm

Posted in On the internet

2 Responses

Subscribe to comments with RSS.

  1. Hi Chris,
     
    Kalido generates SSAS cubes against an underlying star or snowflake schema that is fully time variant, but has 2 further levels of optimization.  The first is where any number of time-variant views can be set (e.g. current org chart, version of the product hierarchies as at 1/1/2008, and geography hierarchies as at the time of each transaction summarized).  These views can be materialized and separately indexed, or may be defined via a relational view.  Then it os possible to manually configure the cube (even though Kalido will manage changes to the underlying schema without disturbing the customizations made manually to any cubes generated).
     
    hope this helps shed some light on the link between Kalido and SSAS…
     
    Cliff

    Unknown

    July 23, 2008 at 9:07 pm

  2. Hi Cliff,
     
    Thanks, this is useful. I wasn\’t thinking about the optimisation of the underlying relational structures, more of the optimisation of the cube itself – things like attribute relationships, aggregations, partitioning and that sort of thing. I\’m not sure how much of that you\’d be able to do automatically – at least some of it would have to be done manually.

    Chris

    July 24, 2008 at 11:28 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,113 other followers

%d bloggers like this: