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?

The same problem applies with Dimensions that are linked in through the
linked cube. If I remove the dimension there is no way to re-add it with the
appropriate relationship to the cube (Regular Relationship) without deleting
and re-adding the linked cube.

--
Steve Loper
Amadeus Consulting

Hello Steve,

Based on my research, this behavior seems to be by design. You may want to
use DSO script to create cube2 so that it could be updated to the new
metadata.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------