Re: Local cube support in AS2005

[Darren Gosbell]

I'm not entirely sure - as I type I am also installing the September CTP
so there may be more info in the BOL there.

What I did want to say was that AS 2005 is meant be a lot lighter in
terms of the amount of information it sends to the client and the amount
of resources it uses on the client. What this means to is that you may
be able to move clients on slower internet connections to server based
cubes.

At the moment AS2k sends a lot of extra dimension information down to
the client. AS 2005 natively speaks XML/A and will only send the
resulting cellset back to the client.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

[Chris Webb]

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/dnsql90/html/sql2k5_asprocarch.asp
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/

"Richard Bond" wrote:

> Does anyone know where I can find information on this subject?
>
> We currently produce local cubes directly via create cube statement.
>
> Will we still be able to bypass analysis services to produce local cubes
> with similar features as the server cubes in AS 2005?
>
> (we use server cubes aswell for clients with decent internet connections)
>
> regards,
>
> Richard

[Simmo]

Isnt it more of a case of building a local UDM rather than a local cube?
--
Simmo

[Chris Webb]

Sort of, although the UDM is nothing more than the cube really.

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

[Simmo]

Can you still use DDL to create a local cube, has this been enriched in 2005
or should we be using XML/A? Also with a local cube in 2005 do we have all
the UDM functionality such as KPIs, translation etc?

[Chris Webb]

By DDL I assume you mean CREATE GLOBAL CUBE, right? Yes, that still works and
is probably the best approach to use initially. XMLA might be a bit tricky to
work with.

If I had a complete list of what features local cubes support in AS2005 I'd
be a happy man. The best thing to do would be to try to build some local
cubes from server cubes with these features and see what happens... if you do
this, make sure you post your findings back here for the rest of us!

Chris

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