ลงชื่อเข้าใช้
 
หน้าหลักLibraryเรียนรู้ดาวน์โหลดการแก้ไขปัญหาชุมชนฟอรัม
ทรัพยากรสำหรับผู้เชี่ยวชาญด้าน IT >
> 
> 
Creation of offline Cubes in SSAS 2005

Unanswered Creation of offline Cubes in SSAS 2005

  • 2 พฤศจิกายน 2548 13:17
     
     
    ลงชื่อเข้าใช้เพื่อโหวต
    0
     
    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
    ผู้ดูแล
     
     
    ลงชื่อเข้าใช้เพื่อโหวต
    0
    Here's a Sept. post to the SQL Server OLAP Newsgroup on AS 2005 local cubes:

    http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/55f1a6e3eeb7ec0a
    >>
    " 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
    white paper:
    http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql9...
    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!

    Chris

    --
    Blog at:
    http://spaces.msn.com/members/cwebbbi/
    >>