Great article Greg.

I studied to be and worked as a professional musician before entering IT. I just fell into it by doing temp jobs to supplement my income (I guess...

This would work, if I understand what you need to do:

DATEADD(dd, -(DATEPART(dw, yourdate)-1), yourdate) AS [Week Commencing]

I think it would be better to ask yourself if you are using the correct BI tools for your needs or if you need to level up MDX skills before...

This guide will take you through the whole process of adding calculations (and everything else):

http://technet.microsoft.com/en-us/library/ms170208.aspx

You have nothing but IDs in your Measure Group and no actual measures.

In order to...

You need to include quarter in your composite keys, I would say, since it's part of the hierarchy. I have just created this dimension as a test and do not...

I have done a little digging and the issue you are having with Mosha's solution (no drill through action showing in excel) is to do with getting the code exactly...

Greetings from the UK! I've just got back from a 2 week holiday in Italy - a little place called Montefoscoli in Tuscany. It's a beautiful country 🙂

Let me know...

I'm not 100% sure but if it's anything like KPIs then there are restrictions when it comes to calculated members - this is because MDX is calculated on the fly...

You can have multiple actions on a cube, doing different things. As for the caption, you are limited only by your imagination (and any reserved characters).

The caption can also be...

I think that the issue is that you only have one version of the project and since you are using different users to open these projects one might have permissions...

In Visual Studio which version of the data are your project data sources looking at?

Are you using solution configurations?

Where are you exploring data, in the dsv or in the...

I have used many of them extensively 😉

All of the documentation for the the assp project is on their codeplex page.

In answer to your specific question, the only way I know of to change the order...

It's returning 17 as there are 17 members in your set.

Augsburg is listed twice but it's still two distinct members that have different properties further up the hierarchy -

[Geography].[Geography].[City].&[Augsburg]&[HH]

[Geography].[Geography].[City].&[Augsburg]&[BY]

One...

I can't see the picture....

But why aren't you using PARALLELPERIOD instead of your cousin>ancestor.lag(1) thing above? It's simpler....

[Code="Other"]

SUM(

PARALLELPERIOD

([Time].[Year - Quarter - Month -...