Re: Creating a local cube from a SQL Table - Chris Webb Please help

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Chris,

Many thanks for your quick response.

So are you saying there is no way of using a DDL to create a local cube
or refresh the cube directly from a SQL table instead of using a server
cube.

Thanks
Karen

Chris Webb wrote:
Hi Karen,

Are you using AS2K or AS2005? If you're using AS2K you'll have to use the
CREATE CUBE statement, which can be very tricky to get right; if you're using
AS2005 then you can use XMLA instead (see the following entry on my blog:
http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!877.entry ,
although this only deals with how to get the XMLA for building a local cube
from a server cube).

The white paper referred to below can be found here:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anserddl.mspx
However it's not going to be any use to you because you can only use this
syntax when building local cubes from server cubes.

You might also want to check out LocalCubeTask
(http://www.localcubetask.com/dnldfr1ocms.htm), but I'm not sure if the local
cube creation functionality is still sold separately.

HTH,

Chris


--
Chris Webb, MVP
Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk
Blog: http://cwebbbi.spaces.live.com/


"KarenM" wrote:

I am trying to create a Local cube directly from a SQL table but I am
not sure how to do it.

I saw the below post by Chris Webb from Microsoft of how to do this.
But I cannot find this URL anymore on microsoft.com can someone please
help.

I want a approach to create a cube with a sample against say a
Northwind table and refresh the cube from the table using DTS. Please
help.

Thanks
Karen

This is Chris Webb's article
--------------------------------------------------------------------------------------------------------------------------------
Hi Andrew,

There are in fact two ways of creating local cubes, the more complex
original method (which is described in BOL and in most books), and the
newer
method which is described in this white paper:
http://www.microsoft.com/sql/evaluation/BI/AnSvcDDL.asp


It sounds to me like you'd be better off with this second method, as it
is
much easier to use...


HTH,


Chris
--



.

Relevant Pages