Only for history reasons:

http://connect.microsoft.com/SQLServer/feedback/details/356575/ssis-no-longer-supports-ole-db-provider-for-odbc-import-export-wizard-etc

The best idea is to use the ME OLE DB Provider For DB2, BUT this work only with the dev or Ent edition of SQL.

No the typical mdx is like that:

[MEASURES].[GC GSV Finance LY]

AS (

ParallelPeriod

(

[Dim Time].[Finance Date Hierarchy].[FYear],

1,

[Dim Time].[Finance Date Hierarchy].CurrentMember

),

[Measures].[GC Gross Value]

)

then you must check, if in your DimTime table has column has...

Thank's denglishbi.

So the solution was very simple.

1st. I kept the typical MDX.

2nd. I added the [Day_Of_Week] & [Day_Of_Week_Name] fields (The second as name column)as attributes on my DimTime.

I added...

Thank's denglishbi.

This is for typical use. Unfortunately my case isn't.

Let's explain exactly, what i want.

If we have a GSV Value for Monday, March 30 2009. if we use the "typical"...

Check this:

http://ssas-musings.blogspot.com/2010/01/excel-and-mdx-multiselect-problems.html