Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Metadata from linked objects is not automatically updated when the source objects change in SSAS

Metadata from linked objects is not automatically updated when the source objects change in SSAS

View products that this article applies to.

Symptoms

You update the metadata for source dimensions or for measure groups in a Microsoft SQL Server Analysis Services (SSAS) database. However, the metadata for the associated linked dimensions or measure groups is not automatically updated as expected.

For example, if you update certain other properties such as "FormatString" and "DisplayFolder," these changes are not reflected in the properties of the linked objects.

↑ Back to the top

Cause

This issue occurs because the metadata (such as the original values of "FormatString" and "DisplayFolder”) is implemented only when the linked objects are created. This behavior is by design. For more information, see Define linked dimensions.

↑ Back to the top

Workaround

To work around this issue, find, drop, and re-create all linked dimensions or measure groups.

↑ Back to the top

More Information

Wherever the source object properties are changed in a project, you have to find, delete, and re-create all linked objects. To do this, you must know which objects are being linked to, and which of the other cubes in the project have linked to these objects.

Notes
  • Processing the cube with the linked objects does not raise any errors. There are no indications that the underlying source objects were changed.
  • Adding new measures into the source measure group is detected when you use the linked measure group.
  • The remote linked objects from Microsoft SQL Server Analysis Services 2014 are obsolete. For more information, see Deprecated Analysis Services functionality in SQL Server 2014.

↑ Back to the top

Keywords: kbsurveynew, kbtshoot, kbexpertiseadvanced, kb

↑ Back to the top

Article Info
Article ID : 2914689
Revision : 1
Created on : 1/7/2017
Published on : 12/11/2013
Exists online : False
Views : 458