dbTalk Databases Forums  

Linked object not refreshing SSAS 2005

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


Discuss Linked object not refreshing SSAS 2005 in the microsoft.public.sqlserver.olap forum.



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

Default Linked object not refreshing SSAS 2005 - 01-10-2006 , 11:02 AM






I have a cube that contains two linked objects (cubes, including
dimension and measures) and when I make a change to the dimensions or
measures of the original cube it doesn't seem to refresh the metadata
in the cube containing the linked objects. The only way that I've been
able to get the information to update is if I delete the linked object
and then re-add it to the cube. That's fine except then I have to go
through and reconfigure all the dimensions, on the Dimension Usage tab,
as well as any other changes that I made to that cube in the combined
cube.

Example:

Cube 1: This cube has at least one dimension and one measure.

Cube 2: This cube is used for linking multiple cubes together.

Steps to reproduce:
- Link Cube 1 into Cube 2, save, deploy, process cubes...everything
works fine
- In Cube 1 add an additional measure, save, deploy, process cubes. At
this stage I usually get an error saying "Errors in the OLAP storage
engine: The metadata for the statically linked measure group, with the
name of 'XXXXX', cannot be verified against the source object."

To make this error go away I have to delete and relink Cube 1 in Cube
2. Shouldn't I be able to just refresh it?


Reply With Quote
  #2  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: Linked object not refreshing SSAS 2005 - 01-12-2006 , 05:03 AM






Hi,

I have the same problem and would be glad if somebody give us some tipps
about this.

Thanks,
Vladimir Chtepa

"JBankson" <jasen.bankson (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1136912563.148156.15830 (AT) g43g2000cwa (DOT) googlegroups.com...
Quote:
I have a cube that contains two linked objects (cubes, including
dimension and measures) and when I make a change to the dimensions or
measures of the original cube it doesn't seem to refresh the metadata
in the cube containing the linked objects. The only way that I've been
able to get the information to update is if I delete the linked object
and then re-add it to the cube. That's fine except then I have to go
through and reconfigure all the dimensions, on the Dimension Usage tab,
as well as any other changes that I made to that cube in the combined
cube.

Example:

Cube 1: This cube has at least one dimension and one measure.

Cube 2: This cube is used for linking multiple cubes together.

Steps to reproduce:
- Link Cube 1 into Cube 2, save, deploy, process cubes...everything
works fine
- In Cube 1 add an additional measure, save, deploy, process cubes. At
this stage I usually get an error saying "Errors in the OLAP storage
engine: The metadata for the statically linked measure group, with the
name of 'XXXXX', cannot be verified against the source object."

To make this error go away I have to delete and relink Cube 1 in Cube
2. Shouldn't I be able to just refresh it?




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.