Hi Sue,

FYI  here is my script quick and dirty  ..put it in your toolbox..didn't need it,  but did the work anyway

--============================================================================

--...

HI Sue,

Found the solution...just use direct sql in the query manager instead
i.e

RESTORE DATABASE [edw] FROM DISK = 'C:\RobinWork\Backups\dbBackup_Source\.EDW.bak' WITH...

Hi Sue,

Thanks for your help..gone for the jugular and writing a script to do it...will post it when done

Thanks Perry ..got it ... you've both (Gail also)  filled in the pieces...looks as if both of these steps are missing from this current process. You deserve a doughnut each...cheers

HI Gail,
Thanks for prompt reply...you've clarified a lot

So to put a bit more belt and braces on this

1) Prior to flipping to SIMPLE mode,...

well believe it....here's the kiddie

SELECT NON EMPTY { [Measures].[Sales Amount] } ON COLUMNS,NON EMPTY { ([Product].[Category].[Category].ALLMEMBERS ) }DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWSFROM ( SELECT

( STRTOSET(@DateCalendar, CONSTRAINED) ) ON...

hi yayomayn

I did some more investigative trial and error stuff and have now got it to work with the subselect. In the subselect the default measure is "internet sales" so...

Hi SSC Veteran,

This kiddie works :

WITH MEMBER [Measures].[MinValue] AS MIN([Order Date].[CalendarHierarchy].CURRENTMEMBER, [Measures].[Sales Amount]), FORMAT_STRING = '0'

MEMBER [Measures].[MaxValue] AS MAX([Order Date].[CalendarHierarchy].CURRENTMEMBER, [Measures].[Sales Amount]), FORMAT_STRING = '0'

SELECT

{[Measures].[Sales Amount],[Measures].[MinValue],[Measures].[MaxValue]} ON 0,

[Order Date].[CalendarHierarchy].[Year].Members ON...

Hi Raunak

It checks out...thx

hi ,

I've been down the mineshaft on trying to learn mdx coming from a TSQL background ...its been one step foward, 3 back all the time...a real ball ache. Don't...

check this out :

MEMBER MyValue as 'DimX].[DimId].currentmember.properties("value")'

SELECT

{[DimX].[DimId].Members, MyValue} ON ROWS,

[Measures].[Mea_1] ON COLUMNS

FROM MyCube

also check out http://www.mdxsamples.com/ ...on why using properties is slow (see bottom para)

thanks Lowell..it checks out

Hi All,

I've checked the target tables again and apologise but they do have identity fields...and that is what is causing the problem..the "bcp in" just generates sequential keys for the...

Hi Mack ,

I'm on a roll...even simpler...using the "null" value brings back the first member of a set on the same level as the current member...only works if you use...

Hi Mack,

Your a diamond among the gems....fixed it...using your reply...gone back and determined the first child and created the set...and then did a tail on it....

-- Previous 3 month sales...