Hi,

Analysis Services SP2. I'm trying to set up a parallel [test] cube build
environment.

In Query Analyzer, copied the necessary fact and dimsion tables from NAME to
NAME_TEST. Then modified the build DTSes, by dumping them (in Enterprise Mgr)
to VB; modified the code with global-query-replace; and reran the VB (it
required some tweaking by hand before I could do so successfully).

I have this all working.

Now I'm trying to modify the [test] cube definition in Analysis Mgr. The
starting point for the test cube was to simply backup and restore the production
cube to a different machine.

In the Cube | Edit window you can right-click on the header of the facts table
(in yellow) and select Replace ... Ah looks just like what I need.

However when I try to save this I get:

Cube AUM is not valid. Internal error.

Tried going at it several ways, but they all produce the same result.

Have searched both the Web and Usenet for these (non-informative) error messages
and have found nothing.

Any ideas?

thanx.

pat

Can u check the following:

- Before trying to replace fact and dim tables, refresh
the data source of the cube.
- Replace the table names in dimension editor forst,
process the dimensions first and then come to cube.
- Optimize teh cube, before you try to save the same.
(Tools menu in cube editor)
- Check whether you are missing any link between any
dimension and fact tables.

Thanx for your message GS,

Refreshing the Data Source is easy enought to do. However when I got to your
item about processing the dimensions before the cube, I discovered (something I
may have known previoulsy) that only shared dimensions can be processed
separately. The dimensions in this cube are all private.

Can't optimize the cube - same immediate 'internal error'.

And yes, one dimension-fact link _is_ missing after I substitute the new facts
table. The one parent-child dimension as it happens. I could (and should)
probably rebuild this by hand (actually maybe I did already and it still barfed
.... I've tried so many things it's hard to remember).

Insead I followed up on something I was thinking about earlier. Remembered that
there was an Add-In somewhere that allowed you to script the cube. I don't care
about the cube's data (just yet) only its structure ... so this seemed of
interest. If I could dump it all out to VB and changed all instances of the
facts table name, things might work.

After some fumbling around, the Add-In is called 'Metadata Scripter'. It's in
the SQL 2000 Resource Kit. Found it; it's VB and builds to a DLL. More
fumbling around. Seems what you have to do to register it is:

call RegsiterAddIn()

in the Immediate window in the VB (6.0) IDE. Hmm guess a simple regsvr32 won't
do it in thie case.

Well that added it in Analysis Services | servername | Properties | Addins.
Click the check-box and then you're told to restart Analysis Services. Do so.

Now where do you go? Seemed to remember that something (I've done this once
long ago) magically appeared in a context menu.

Don't find anything new in any of the menus. Read the code some more. At the
bottom of COlapAddin.cls it tells you that it should go under the 'All Tasks'
menu item for a variety of objects (eg, Server, Database, Data Source).

Except there's no 'All Tasks' anywhere! Huh. I'm running 8.00.382 of Analysis
Manager. I think that's sp2 of AS2K (the most recent). And the VB code is from
2000. Maybe All Tasks has gone away? If so, where then do Add-ins (because
they do appear to still be there) hook in visually?

pat



In article <048001c348c8$2919ed90$a001280a (AT) phx (DOT) gbl>, "GS" says...

Some progress. Am using the MetaData Scripter.

Found an old thread in Google Groups. Started by Andy Ball in the UK in Aug
2002. Most recently added to by Matt Pampena in April of this year. Seems that
one can't reply to Google Groups more than a month old so I'm doing it this way
(and CCing the two).

Matt, you have to register twice. Once with the RegisterAddIn procedure that
you mentioned (although it's easier just to open an Immediate window in the VB
6.0 IDE and do call RegsiterAddIn()<RETURN> ... a dialog will pop up indicating
that the procedure ran).

But you also have to register the component (dll) itself. You can do this
either simply by building (and think the IDE will say something to the effect
that it registered the component). Or you can use regsvr32 (from CMD, do
regsvr32 /?).

I'd done the first and 'All Tasks' didn't show up in my Analysis Mgr either.
Once I'd done the second as well 'All Tasks' with the metadata item inside it
did show up and I was able to run and produce a .vbs.

And my second question for Andy. Vaguely aware of WSH and cscript. Tried it
just now and got:

** L:\pf\SQL Server\AUM>cscript aum.vbs
** Microsoft (R) Windows Script Host Version 5.6
** Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
**
** L:\pf\SQL Server\AUM\aum.vbs(21, 4) Microsoft VBScript runtime error: Type
mismatch: 'BuildCube'

I would have thought cscript had all 'references' (in the VB project sense)
built-in but maybe not?

pat






In article <bevf3d0asl (AT) drn (DOT) newsguy.com>, Patrick says...

Ah I see (at last).

BuildCube and its variants are also a part of the same project.

That is, you copy the .vbs code generated by the Analysis Mgr add-in (MetaData
Scripter) into the appropriate spot in ScriptFooter_Routines.bas (which contains
BuildCube, etc) and then you can use the same method of 'calling from Immediate'
with:

call RunScript()<RETURN>

This works and rebuilt a modified cube that, to get back to my original problem,
no longer generates an 'Internal Error' messsage.

pat



In article <bf1jdc016ab (AT) drn (DOT) newsguy.com>, Patrick says...