dbTalk Databases Forums  

Re: Local cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: Local cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Matthias Englert [MIS]
 
Posts: n/a

Default Re: Local cube - 07-01-2003 , 09:09 AM






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...
Quote:
Does anyone know how to generate a local cube (.cub) from MS analysis
services ?

I have SQL 2000 and the analysis services running.

Thanks in advance

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...




Reply With Quote
  #2  
Old   
Tim Peterson
 
Posts: n/a

Default Re: Local cube - 07-01-2003 , 11:12 AM






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

Quote:
Does anyone know how to generate a local cube (.cub) from MS analysis
services ?

I have SQL 2000 and the analysis services running.

Thanks in advance

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...




Reply With Quote
  #3  
Old   
Ermanno Bonifazi
 
Posts: n/a

Default Re: Local cube - 07-01-2003 , 12:44 PM



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

Download a demo version from our site.

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

Quote:
Does anyone know how to generate a local cube (.cub) from MS analysis
services ?

I have SQL 2000 and the analysis services running.

Thanks in advance

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.