No problem Ludo, glad to help.

You need to look at the Unknown Member processing options in the Dimension model.

This article on technet should help you Unkown Member

Unfortunaltey you need to add the unknown member...

If you dont want to alter the table then steves solution is the optimal one, however, you will most likely lose drill down functionality it depends on the business requirements...

If you are using SQL server 2005/8 then take a look at the Adventure works cube to get the general Idea as that has a very good example in the...

Alternatively you could have a post process script that updates a flag on the Time dimension which can then be filtered on by using a view. It would save...

It is a bit of a limitation, unfortunately I'm not aware of anything out thier that will behave any differently.

You might be able to use the MDX Order() function to...

The Key is only used in Analysis services, when you sit any reporting tool on top of an SSAS cube the key becomes irrelevant.

As a result Excel knows nothing...

I've used this method for a number of years, and commonly explain it to business users as a Contra-Correction, which they seem to readily grasp, in one instance a client...

dave-dj (12/17/2010)

FAO tskelly:

If your finding the standard SCD component of SQL slow, have a...

Its a good article.

However, did you experience any problems with datatypes being incorrectly assigned using the SELECT..INTO.. method, I notice you mention that nulls are handled in the consolidation layer...

Like others Ive always used the CAST or Convert functions for converting numbers to strings and so didnt know the pitfalls of using the STR() function so it was a...

A very good solution and something that we've implemented in one of our solutions, the only difference is that we also have a RelationshipType table hung off the HeirarchyRelationship table.

The...

I think this would be of use in planning/supply systems where you want to know about future availablity of resources.

However it is slightly misleading in that I would have thought...

Nice article and something I've done numerous times, though in past ive used it for seasons, especially usefull in the retail and the travel industries, where there are Spring/Summer, and...

Like Nils, I dont quite understand the reason for the article, in 95% of cases the sort operation is the least of your worries in a plan, especially when you've...