Hi,
I was trying to create Global cube thru VB
using following code

strCreateCube = "CREATE GLOBAL CUBE [WarehouseLocal] "
strCreateCube = strCreateCube & "STORAGE 'C:\DBOUtletReports.CUB' "
strCreateCube = strCreateCube & " FROM [DBOUtletReports]"
strCreateCube = strCreateCube & "(MEASURE [DBOUtletReports].[Sales], "
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[Product],"
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[outlet],"
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[Distributor],"
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[Outlet Type],"
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[Time Period],"
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[Outlet Class], "
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[DBBrand],"
strCreateCube = strCreateCube & "DIMENSION [DBOUtletReports].[Time]"
strCreateCube = strCreateCube & "(Level [Year],"
strCreateCube = strCreateCube & " Level [Month],"
strCreateCube = strCreateCube & " Level [Week],"
strCreateCube = strCreateCube & "MEMBER [Time].[jan-2004]))"


when i execute it gives below error

Formula error - the member "[Time].[jan-2004]" is not part of the level "Year".


I have time dimension as Levels YEar,Month and week

Month has members like Jan-2004,Feb-2004 and Year has years only

I wanted something like the above it works fine with "MEMBER [Time].[2004]))"

Any ideas appreciated