I used parameters instead of fields, but the following should do exactly what you want. Basically does a divide by 12 with no remainder (removes your need to round)...

You could try using the ABS() function. Usually you apply this to measures versus dimensional values though.

Will assume you still have anonymous access set to enabled on your IIS virtual directory. Because of this, the user identity being passed to SSAS is the NT AUthority\Anonymous...

Would appear your account isn't part of the SSAS administrators group? Is your account a member of the local Machine Admins group (ie the windows group)? By default,...

I've seen similar errors when the DSV hasn't been updated and the partition query is manually updated to include the new column. Is the column showing for the table...

You should be ok creating the calc member in the cube. Either it will work naturally, that is, you have a measure call # of children and another called...

At least SSIS 2008 has a Migration Wizard, I can only assume 2005 had one also before it.

Details on using it are here.

Why ask everyone for samples? Obviously you're...

I haven't tried it but you *might* be able to utilize the Stored Procedures functionality of SSAS for this too. I think they're all .net classes, referenced in memory...

Are you saying that when you select the option to Ignore Errors, that when processing, this selection is ignored?

If you're *not* saying that, but that, it works when you select...

MWC, maybe you could also make use of checkpoints and the event model? Checkpoints to be able to restart from the point of failure (or at least the batch...

You beat me to it Elliot - i strongly second the EXEC SQL approach you outline, *way* easier.

Hey Don,

I realize I'm being pedantic but I would still try to drive your user/s to a clear reason as to why they need to see ~ 175k rows in...

Agree with both points Dan made. Note that based on what info you've provided, aggregations may not help much at all as it *appears* that you're trying to bring...

THe msft technet article on how to do this is here.

Note, you normally *don't* put the full URL in there, only the relative path (see the article for the details).

Any chance of posting the SQL? Would make it significantly easier to try and determine the cause.

Also, not sure if you tried, but dobule-clicking the error in SSMS will...