true true, i guess with only half a question asked, we'd give only half an answer 😉

In case you are looking to do this in SSIS and not SQL, you're looking for the conditional operator (which, if you used that in a google search, it would...

Sorry, I realize I basically short-handed my response.

I was referring to a Derived Column Transformation. My Data Flow is made up of 3 components - the Ole DB Source,...

Yep, so on the OLE DB source, set the truncate error to ignore. In the derived column, instead of entering a name, selected the 'replace Name with' option (where Name...

Like Steve, I when adding a derived column and setting the ignore truncation error on the OLEDB DB source, it works perfectly.

Are Valid and Invalid the only two options? If so, then don't filter this dimension at all. This assumes that you haven't set either of these values to be...

Basically it's working 'as intended' 🙂 but that doesn't overly help you.

Assuming what you want is to still only display the members that have a count value in your Number...

Yep, same as for 2003 but you do need the 10 versus the 9 version as you noted. I think 6 SP1 is the latest XML release, but...

BTW, I think only Enterprise and Dev support this but would be worth checking (would almost be my life that Standard *does not*).

Sounds like classic scale-out? You can prob google many docs on this, the first on my list was this.

Zabastian,

What exactly do you expect to see at the aggregated/higher/highest level of the cube? That is, if you don't want to sum (which I agree would be wrong) or...

It was an example, not going to do all of the work for you 🙂 (ie if you play with those operatorsyou'll find the combination that...

The data connection can be different on the server than when it's in the project (ie the properties of using windows credentials, sql credentials etc etc can all be modified,...

If you're looking for one of the best overviews (and detailed analyses) of M2M, especially in an OLAP/SSAS context, then Marco's is the best (IMHO :-)).

It's here.

You should be able to use either CELL CALCULATION or SCOPE statements in the MDX script within the cube.

The official doc for CELL CALCULATION can be found here.