Hi,

one way is to use the create global cube statement from DDL.

CREATE GLOBAL CUBE [Sales]
STORAGE 'C:\...\test.cub'
FROM [Sales]
(
MEASURE [Sales].[Unit Sales],
MEASURE [Sales].[Store Cost],
....

DIMENSION [Sales].[Customers],
DIMENSION [Sales].[Education Level],
DIMENSION [Sales].[Gender]
....
)

HTH,
Matthias

"Guillermo" <gpita (AT) safjp (DOT) gov.ar> schrieb im Newsbeitrag
news:#UM5LB9PDHA.3880 (AT) tk2msftngp13 (DOT) phx.gbl...

Another way is to install our add-in. After installing, OLAP Client Manager
Add-in will appear as a menu choice whenever an Analysis Server database or
cube is selected. Select the Add-in, choose the local cube, and push the
Create Local Cube button and you have a local cube.

Free 30-day trial available:

http://www.localcubetask.com/dnldfr1ocms.htm

Other features:

Create local cubes for many cubes at the same time.
Remove unwanted dimensions, measures, members, etc.
Create multiple local cube, each one sliced on a different member
Create multiple local cubes for different roles.
Create local cubes that translate a server cube into other languages.
Schedule creation and distribution with the Local Cube Task in DTS.
See the CREATE LOCAL CUBE statement or the CREATE GLOBAL CUBE statement for
the local cube.
Generate VB modules that will create a local cube.
Put the local cube into a CubeSlice file that automatically displays the
data when a user clicks on it.

Tim Peterson
www.localcubetask.com


"Guillermo" <gpita (AT) safjp (DOT) gov.ar> wrote

http://www.solgenia.com/USA/Solution...SheetRubik.htm

Download a demo version from our site.

"Guillermo" <gpita (AT) safjp (DOT) gov.ar> wrote