Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Local Cubes and .NET 2.0

with 5 comments

Here’s a little nugget of information I thought I’d post here for future reference: if you want to create local cubes direct from relational sources in AS2005 you need to have .NET 2.0 installed on your machine, although you don’t need to if you’re creating your local cubes from server cubes. I’m sure someone will find this useful… thanks to Siva for letting me know about this.

Written by Chris Webb

April 6, 2006 at 10:04 pm

Posted in Analysis Services

5 Responses

Subscribe to comments with RSS.

  1. Do you have any links on how to acomplish this?


    April 10, 2006 at 2:36 pm

  2. What, build local cubes direct from relational sources? No, I\’m afraid not – I don\’t think it\’s documented anywhere, and I\’d need a bit of R&D time to work out how to do it if I was doing it myself. I guess what you\’ll need to do is get the XML cube definition of a server cube built from the same source, then look at the XML to build a local cube from that server cube (which you can get by running a Profiler trace and executing a CREATE GLOBAL CUBE statement) and then try and merge the two together…


    April 10, 2006 at 3:39 pm



    April 13, 2006 at 6:57 am

  4. Chris,

    The company I work for currently creates local cubes directly from a relational source using PTS and CREATE CUBE, but didn\’t think it would be possible with AS2005. 
    You mentioned that Siva gave you this information.  One might assume that he would know how to create local cubes from a relational source under AS2005.  Is there any way you could find out from him and post the information?  Or provide contact information so he could be asked directly?
    Thanks a lot!


    April 14, 2006 at 6:03 pm

  5. Keith,
    Siva works in the test team at Microsoft; from the context of the email he sent, I don\’t think he has direct experience of creating local cubes from a relational source. The only person I know of who has had much experience of local cubes in AS2005 is Tim Peterson of (he is the local cube guru) you might want to contact him to see if he can help.


    April 16, 2006 at 3:47 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 4,002 other followers

%d bloggers like this: