Hi Iain,

"I am guessing that your solution is to create a calculated member within the query?" Yes that what I was doing?

What are you trying to get - is this...

Try

Avg(

{[Time].[Month].CurrentMember.Lag(1):[Time].[Month].CurrentMember},

[Measures].[Period Demand])

Mack

Are you changing the correct ODBC driver? Have you created a user DSN and are changing that? Do do you have 32 & 64 bit versions of the ODBC...

Hi Iain,

Try this sort of thing - In my example I have created a memeber that would be your calulation (in this case % European clients) and then unioned that...

Sounds like he doesn't have access to the cube or cannot connect to your machine

Have you granted them access to the cube?

If you have, did you use localhost...

When SSAS errors you will often see the error messages under the measure group or dimension (whatever has failed) that are processing at the time whether they have failed or...

Have you given them access to the cube?

You can use the HAVING function

SELECT NON EMPTY { [Measures].[Net Revenue] } ON COLUMNS ,

NON EMPTY { DESCENDANTS( [Date].[Date Hierarchy].[Year].&[2012], [Date].[Date Hierarchy].[Month] ) }

HAVING [Measures].[Net Revenue] > 100000

ON ROWS...

Use a measure expression or feed this in pre-calculated into the cube

Mack

I experienced this when we move to use XLCubed (an excellent OLAP tool BTW).

What I did was alter a couple of SSAS setting

I increased the # of...

Is this not working for September Days 1 to 10 or are you looking for an aggregated view of September Days 1 to 10?

The query looks like it...

Are you wanting to see dimensions in a particular order or want to custom order members of a dimension?

Custom ordering members of a dimension is possible

Custom ordering the dimensions is...

I guess the issue with the MDX I posted is that you are querying the revenue without specifying a date

The following MDX may work (although I have syntax checked it)

select...

ahhhhh that issues rings a bell :hehe: I think it's specific to BIDS tho

I think your date needs to be associated with the measure like below

select [Measures].[Net Sales Value] on columns,

toppercent({[Customer Information].[Customer Acc].[Person No].members},20,Sum(tail([Order Date].[Order Date].[Month],36) ,[Measures].[Net Sales Value])) on rows

from marketingcube

Lemme know...