| Author |
Topic |
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
 Posted - 2002-03-04 : 08:02:16
|
Probably a really basic question but...Can I create a cube from QA - I tried create cube ... but that produces a syntax error.Am I being really stupid????============The Dabbler! |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 12:47:02
|
| No,QA operates on the relational engine, not on the multidimensional engine. You can create cubes through the Analysis Manager.-Chad |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-03-04 : 14:50:33
|
| So how do you script the creation of Analysis Services cubes? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 15:33:16
|
| You would have to code that (With VB or some other language).See 'Using the CREATE CUBE Statement' in BOL.-Chad |
|
|
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
Posted - 2002-03-04 : 16:18:04
|
| Shame - I was hoping to be able to automate cube creation using metadata stored in the relational engine, using stored procedures etc. I guess we'll ahve to wait for that till further releases.Anyone got any pointers to doing this using VB (reference material other than BOL) - I'm a bit of a novice when it comes to VB and could do with more of a hand holding reference than BOL.============The Dabbler! |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-03-04 : 17:25:51
|
| Chad, in 'Using the CREATE CUBE Statement' it's talking about "local cube"s. Does CREATE CUBE work on server cubes too? Judging from comments on ever-reliable Usenet, I thought not... in fact, every time it's mentioned, someone called Michael Acosta pops up to promote a DSO/XML conversion library... what's the deal here?Edited by - Arnold Fribble on 03/04/2002 17:38:16 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 18:09:47
|
| Unfortunately I'm not as comfortable with Analysis Services as I am with SQL Server. I wish I could help out a little more, but my OLAP experience is pretty limited.I would suspect it would work on server cubes, but I'm not really sure. I have always just used AM when creating my cubes, I haven't delved into the internals.Sorry,Chad |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-05 : 07:51:13
|
| Hey! Chad. a small request.Why dont u try getting a Analysis Services Expert hooked to this site. Am sure you might be knowing quite a few people in MS . It will be great if we get a good resource on Analysis Services.-------------------------------------------------------------- |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-03-06 : 17:16:46
|
| Nazim, Firstly, Look at the "MDX Sample Application" installed in the analysis services program group - it is a sample but is also the "Query Analyser" of Analysis Services. It lets you query the multi-dimensional database. AS it happens, CREATE CUBE is an MDX statement. Secondly, you can automate the Analysis Manager functionality using DSO from languages like VB. There are examples of this in BOL.Finally, you can automate local cube creation using the CREATE CUBE and INSERT INTO statements in the connection string with the MSOLAP OLE DB provider. ADOMD is convenient for coding this. Also, you can create local cubes (.cub) using the OLAP Cube Wizard which installs with Office 2000. You can also include this as a reference in your VB code and automate it.I have three books from which the above is basically regurgitated:- Step By Step Microsoft SQLServer 2000 Analysis Services- MDX Solutions- SQL Server Developer's Guide to OLAP with Analysis Serviceshope that helps... |
|
|
|
|
Create Cube