Reviewing old posts, Mosha made reference to a white paper on creating local
cubes several years ago. It looks like there were subsequents references to
it or something like it, but those references are dead. Is that still
available?

Secondly, I am trying to build a local cube similar to a server cube I
previously created, but I want to build the local cube directly from the
relational source, not the server cube. The server cube uses
calculations in the Select portion of the Insert Into statement to
present the .key and the .name part of a time dimension level.
Something like

DatePart(year,dbo.Time.DateTime),
'Week ' + convert(CHAR, DateName(week, dbo.Time.DateTime)),

This Select statement works fine using the SQL Query Analyzer tool, but
trying this with the Create Cube / Insert Into local cube building
process crashes. If I delete the time dimension from the process, the
local cube builds fine. If I use the Type Week option with the Time
dimension and let the cube automatically create the time dimension
level, it works, but the .name is the same as the .key and is just a
numeric, not a nicely formatted name.

Any suggestions?

Lanny