Chris Webb's BI Blog

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

MDX Scripts article

with 3 comments

I didn’t realise this was freely available until just now, but here’s an article I wrote for the April edition of ‘SQL Server Professional’ on MDX Scripts:
It’s adapted from the chapter I wrote on the same subject for ‘MDX Solutions’, although the big difference is that for this article I used Adventure Works for my demos whereas in the book IĀ used a cube I built specifically for the purpose.

Written by Chris Webb

April 28, 2006 at 3:27 pm

Posted in On the internet

3 Responses

Subscribe to comments with RSS.

  1. I wish someone would tackle the subject of calculations in the multi hierarchy world of the UDM. Ie. how do you handle calculations consistently across all hierarchies in a dimension (especially time/date).

    peter

    April 28, 2006 at 7:23 pm

  2. I beleive that making calculations work in multi hierarchy world of UDM is simpler than it seems, when the attribute relationships are defined correctly. For example, instead of doing ParallelPeriod over YMD hierarchy and watching it not working in YQW hierarchy, it is much simpler to define Year.PrevMember on the Year attribute hierarchy…

    Mosha

    April 29, 2006 at 5:32 am

  3. really?
    good.

    du

    April 30, 2006 at 11:32 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,310 other followers

%d bloggers like this: