dbTalk Databases Forums  

AS2000: Restore of cube database fails

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


Discuss AS2000: Restore of cube database fails in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Barrett Jensen
 
Posts: n/a

Default AS2000: Restore of cube database fails - 03-03-2004 , 07:33 AM






Hi,

I have a cube containing a parent-child dimension, which is included in the
following calculated member:

([Goods].&[Key01|01|Amount total| | |],[Measures].[Month number])

The calculated member works just fine in the cube, HOWEVER when I archive
the cube database and tries to restore it, I get the following error when
the restore process tries to update the repository:

"Unexpected error encountered while updating repository Item cannot be found
in the collection corresponding to the requested name or ordinal."

I suspect that the the problem is somehow related to the parent-child
dimension but I can't figure out, what is wrong. Could this be a bug in AS?

Thanks in advance.

--
Michael Barrett Jensen



Reply With Quote
  #2  
Old   
Michael Barrett
 
Posts: n/a

Default Re: AS2000: Restore of cube database fails - 04-15-2004 , 12:16 AM






Quote:
Hi,

I have a cube containing a parent-child dimension, which is included in
the
following calculated member:

([Goods].&[Key01|01|Amount total| | |],[Measures].[Month number])

The calculated member works just fine in the cube, HOWEVER when I archive
the cube database and tries to restore it, I get the following error when
the restore process tries to update the repository:

"Unexpected error encountered while updating repository Item cannot be
found
in the collection corresponding to the requested name or ordinal."

I suspect that the the problem is somehow related to the parent-child
dimension but I can't figure out, what is wrong. Could this be a bug in
AS?

Issue resolved by replacing the character '|' with '*' in the key column...

--
Michael Barrett Jensen




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.