2 พฤศจิกายน 2548 13:17
Hi, I have a problem creating offline cubes (Local Cubes) in SSAS 2005. "How to create an offline cube and insert data into it using SQL Server Analysis Services 2005" ? Please help me in this regard. -- Gautham
4 พฤศจิกายน 2548 1:44ผู้ดูแลHere's a Sept. post to the SQL Server OLAP Newsgroup on AS 2005 local cubes:
" noWrap bgColor=#b71c0c>Chris Webb Sep 29, 7:21 am show options Newsgroups: microsoft.public.sqlserver.olap From: "Chris Webb" Date: Thu, 29 Sep 2005 05:21:03 -0700 Subject: RE: Local cube support in AS2005
I don't know of any publicly-accessible sources of information for local
cubes, but yes, you will still be able to produce local cubes directly from a
relational source in AS2005. As with a lot of things in AS2005 there have
been a lot of changes with this area of functionality so here's a brief
overview of what I understand...
* The CREATE CUBE and CREATE GLOBAL CUBE syntaxes that we used with AS2K are
still supported with AS2005. However, the CREATE CUBE syntax can't be used
against AS2005 server cubes (although it still will work against AS2K cubes).
* There's also a new way of creating local cubes, and that's using XMLA. For
a good overview of using XMLA to define and process server cubes see this
Unfortunately it doesn't deal with local cubes specifically, but it will
give you a good general introduction to the subject.
* CREATE GLOBAL CUBE statements are in fact translated into this XMLA syntax
by the server when they're issued, so the easiest way to see how to build
some local cubes with XMLA is to run a CREATE GLOBAL CUBE statement while
running a Profiler trace.
Hopefully this is enough information to get you going!