I am trying to link a measure group from a cube in a different AS database
(but on the same server), and get the following error when I process the
cube:

"Errors in the OLAP storage engine: The metadata for the statically linked
measure group, with the name of 'AD043', cannot be verified against the
source object."

I am using the BI Development Studio for SQL Server Analysis Services 2005.

[response copied from
http://forums.microsoft.com/MSDN/Sho...9270&SiteID=1]
When you create a linked MeasureGroup on a AS2005 server A, you specify its
Source as a MeasureGroupBinding with these important properties:

- the DataSourceID pointing to the DataSource whose connection string points
to the AS2005 server B on which the source MeasureGroup is

- the Persistance: an enum value, NotPersisted or Metadata; NonPersisted is
the default and it means that the linked MeasureGroup content from server A
will be pulled from the source server B at the time of creation. So a
connection from server A is opened to server B. That's why the account for
the AS2005 service on machine A needs to have permissions to AS2005 on
machine B to read the source MeasureGroup. If the Persistance however is
specified as Metadata, it means that you are sending manually the content of
the linked MeasureGroup (so you specified the linked Measures one by one).
In this case, a connection from A to B is still opened to verify the
consistency between the linked MeasureGroup and its source. This
verification adds more rules (that would generate the same error you are
getting): the linked Measures need to be defined in same order as in the
source MeasureGroup and they need to have the same DataTypes and
AggregationFunctions as their source Measures.

Adrian Dumitrascu.



"Dan Scott" <DanScott (AT) discussions (DOT) microsoft.com> wrote