Build a local cube

Question

Build a local cube

Del Piero

SSCrazy

Points: 2265
More actions
August 4, 2005 at 12:30 pm

#152496

Hi all,
Is it possible to build a local cube file (*.cub) from Analysis Services cubes by running the create local cube MDX statement in an openquery to the linked server linking to the Analysis Services cube? I am thinking if I can use a stored procedure to build a local cube instead of using the ADO MD object library or using Excel ...
Thanks,
delpiero

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mikespoff Newbie Points: 3 More actions · Answer 1

Hi DelPiero,

Are you trying to build a local version of an on-line cube, or build up a cube from data in a SQL database? To build a cube from a SQL DB, you can use the ADODB.Connection object with an MDX statement. (You'll need to reference the ADODB library to use this object).

For a useful tutorial on building local cubes from an on-line database in a VB .NET application, check out: http://www.localcubetask.com/createwithvb.htm

Hope that gives you a few ideas!

Del Piero SSCrazy Points: 2265 More actions · Answer 2

Thanks,

I am trying to build a local version of an online cube, having a cube in Analysis Services with SQL 2000 DB as data source, and I wanna build a local cube so that I can open the cube in Excel. I think that's what you mean...

I also tried the sample project from your link, it's OK and I successfully created the local cube in VB 6.0. But I am just wondering if we can put that create local cube statement as an MDX and run it through a linked server in T-SQL?

Thanks,

delpiero

Del Piero SSCrazy Points: 2265 More actions · Answer 3

Actually if I run a statement in Query Analyer like:

select * from openquery(<Linked Server Name>, ' <MDX Create Cube statement>')

The cube is actually created, but at the same time there is an error returned:

OLE DB provider 'MSOLAP' reported an error. Command was not prepared.

OLE DB error trace [OLE/DB Provider 'MSOLAP' IColumnsInfo::GetColumnsInfo returned 0x80040e4a: Command was not prepared.].

What is the correct way to do this in Query Analyzer? Or how to prevent this error message?

Thanks,

delpiero