Is this Integration Services or Analysis Services you need help with? You post says SSAS but it sounds like you mean SSIS

Mack

To convert a date to yyyymmdd you could use convert like in the following example:

select Cast(convert(varchar, getdate(), 112) as Int)

Mack

I wouldn't have thought you'd need to do that if the date format was an integer yyyymmdd and you are ordering by the key

Still if it works then job's a...

Did you incrementally process it? (A full process may be required)

Also:

What order are the dates in?

Is it just the date that is in the wrong order or any...

Hi Chris,

The SQL is quite hard to read (and I have never come across case statements & cursors used like that before) but rather than using a cursor couldn't you...

Try something like:

with member [Measures].[Monthly Adjusted Cost] as

IIF(Exists([Calendar].[YearMonthLabel].CurrentMember, {null:[Calendar].[YearMonthLabel].&[201101]}).COUNT > 0

, [Measures].[Cost AMT]*0.95

, [Measures].[Cost AMT])

select non empty [Calendar].[YearMonthLabel].[YearMonthLabel].Members on rows

, {[Measures].[Cost AMT], [Measures].[Monthly Adjusted Cost]} on columns

from [CostCube]

It...

I don't understand why you'd need to join two MDX queries together. In the above example wouldn't you just have a set with the multiple dates you want to...

Could you be using Enterprise SSAS & Standard SQL Server?

Mack

Can you provide he entire query as the syntax looks okay (have tested it on my cube)? Or have you added this to the cube itself?

Mack

I'm a big fan if XLCubed (www.xlcubed.com) which is an Excel addin for SSAS.

It does handle SQL queries though

Mack

I also do something similar with this sort of MDX

TAIL(NONEMPTY({[Date].[Month].[All].Children},{[Measures].[Net Revenue]}),1).Item(0).UniqueName

Mack

Try...

member [Measures].[Date String] As

"[Date].[Date hierarchy].[Date].&[" + CSTR([Measures].[Date].Value) + "]"

,non_empty_behavior = [Measures].[Date]

Mack

What is the syntax of the query you are running (not the calculated member)? If you are using Excel you need to run a trace on the server to...

Hi,

It depends on two factors

What is the most common date used for querying - therefore the users queries will be quicker if partitioned correctly

Or do you get a date...

The syntax I provided is correct (have checked :-P)

What MDX query are you running to get the error?

Mack