using your example

Avg( LASTPERIODS(30,[Order Date].[Actual Date].CurrentMember), [Measures].[Order Line Regular plus Web Sales Total] )

try

iif([Measures].[Order Line Regular plus Web Sales Total]<>0,Avg( LASTPERIODS(30), [Measures].[Order Line Regular plus Web Sales Total]...

The TopCount function looks at a 'set' and then takes your selected 'count' and applies it to this set for your selected 'measure'.

However a 'set' has to be enclosed in...

Is the measure 'Appointed FTE' a calculated measure?

If so then the cube is doing the calculation and then checking to see if it is empty and it is doing...

I wonder what benefit questions like these have to the community at large.

I thought the question of the day was there to inform not just to make the author feel...

The format of the table names indicates that it is a write-back table. Has the writeback option for the cube been switched off/on and/or has a dimension been added or...

Font swapping is still occurring. Font is getting gradually smaller. But its ok my guide dog has been ordered!

We had a similar requirement.

We created a named set within the cube that sat within the Time dimension that searched the cube data for the last recorded week. We called...

Good book to get for understanding MDX is

"Fast Track to MDX"  ISBN 1852336811.

Also checkout the on-line series of articles by William E Pearson starting with the 1st one at

http://www.databasejournal.com/features/mssql/article.php/1429671

Although...

In the sheet that the users are using write a macro that on close copys the sheet to another spreadsheet that has a consistent name and is in a consistent...

ProClarity is a very good tool for users. It is now owned by Microsoft so it should not be expensive per user.

Consider using a Dynamic Properties Task in your DTS package.

Within this task you can formulate, via an SQL statement, your filename (i.e. standard description + yesterdays formatted date and then...

What levels does your time dimension support ?

If the levels are Year,Quarter,Month,Day then a simpler solution might be to generate your time dimension from another table (not the 600 m...

You can do this in DTS. We do this every day as part of an interface between ourselves and a customer.

In a DTS job use a Execute Process Task that...

Ok I give up!

Where did they hide the query?

What is the purpose of QOD. Is it to help explain the use of SQL Server etc or to indulge in obscure quirks and bugs.

In my opinion both statements contain...