dbTalk Databases Forums  

Virtual Cube invalidated during AMO cube update

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Virtual Cube invalidated during AMO cube update in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dand
 
Posts: n/a

Default Virtual Cube invalidated during AMO cube update - 06-26-2006 , 10:56 AM






Hi All,

I'm using AMO to add a dimension to a cube. There is a virtual cube based
on that cube. When I attempt to update the "parent" cube, I get an error
that the virtual cube will be invalidated. I can use the the
"analyzeImpactOnly" parameter to verify that the virtual cube will be
impacted, but that doesn't help me get the updates done.

I've tried UpdateOptions.AlterDependents, but then I get an error that the
updates must be "fully expanded."

Any ideas?

Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Virtual Cube invalidated during AMO cube update - 06-27-2006 , 08:04 AM






The first parameter that the .Update() method takes is of the
UpdateOptions enumerated type. Books online states that this enumerator
has the following values

AlterDependents
Default
ExpandFull

Maybe try calling update() with the ExpandFull option instead of
AlterDependants.

However I am not entirely sure that this will fix your issue. AS2k5 does
not actually have virtual cubes as such. If you upgraded a virtual cube
from AS2k you will find that it has come across as a cube with linked
objects (measure groups/dimensions). I think that you may find that you
have to drop and re-link a linked object if the parent object was
changed.

Another option is that you may be able to do away with the cube(s) with
linked objects and setup a single cube in AS2k5 containing multiple
measure groups.

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

In article <F8A3C7FA-FD28-4518-A2A6-70244A2CA3BD (AT) microsoft (DOT) com>,
Dand (AT) discussions (DOT) microsoft.com says...
Quote:
Hi All,

I'm using AMO to add a dimension to a cube. There is a virtual cube based
on that cube. When I attempt to update the "parent" cube, I get an error
that the virtual cube will be invalidated. I can use the the
"analyzeImpactOnly" parameter to verify that the virtual cube will be
impacted, but that doesn't help me get the updates done.

I've tried UpdateOptions.AlterDependents, but then I get an error that the
updates must be "fully expanded."

Any ideas?


Reply With Quote
  #3  
Old   
Dand
 
Posts: n/a

Default Re: Virtual Cube invalidated during AMO cube update - 06-28-2006 , 11:59 AM



Thanks, Darren. I tried the ExpandFull option to no avail.

I don't necessarily have control over what items are linked in a cube--I'm
processing arbitrary cubes. So, I'm probably going to have to specify that
my program does not support linked objects :-(

"Darren Gosbell" wrote:

Quote:
The first parameter that the .Update() method takes is of the
UpdateOptions enumerated type. Books online states that this enumerator
has the following values

AlterDependents
Default
ExpandFull

Maybe try calling update() with the ExpandFull option instead of
AlterDependants.

However I am not entirely sure that this will fix your issue. AS2k5 does
not actually have virtual cubes as such. If you upgraded a virtual cube
from AS2k you will find that it has come across as a cube with linked
objects (measure groups/dimensions). I think that you may find that you
have to drop and re-link a linked object if the parent object was
changed.

Another option is that you may be able to do away with the cube(s) with
linked objects and setup a single cube in AS2k5 containing multiple
measure groups.

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

In article <F8A3C7FA-FD28-4518-A2A6-70244A2CA3BD (AT) microsoft (DOT) com>,
Dand (AT) discussions (DOT) microsoft.com says...
Hi All,

I'm using AMO to add a dimension to a cube. There is a virtual cube based
on that cube. When I attempt to update the "parent" cube, I get an error
that the virtual cube will be invalidated. I can use the the
"analyzeImpactOnly" parameter to verify that the virtual cube will be
impacted, but that doesn't help me get the updates done.

I've tried UpdateOptions.AlterDependents, but then I get an error that the
updates must be "fully expanded."

Any ideas?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.