Does Linked Measure Group allows to delete the not used Measures for that cube?

Question

Hello all,

I just want to know something related to the linked Measure Group within SSAS .

I have developed the Linked Measure Group in order to share data across cubes within duplicating data for sharing same Measure Group within multiple cubes .

While processing a cube I got certain error and all I want to know that

Let's say we have a cube A and Cube B and we create a linked Measure group within cube B by using a Measure group of Cube A  and within linked Measure Group in Cube B , we delete some measures that is not needed for cube B and Processed cube B.

Then  I got certain error while processing a cube B.

But It’s strange that it won’t give any issue while deleting the dimension that linked within Linked Measure group in Cube B.

So, does Linked Measure group allows to delete the not used Measure for that cube.

If we process the cube without deleting any Measure from Linked Measures then successfully both the Cube A and Cube B processed.

Also ,just a quick do we need to process the Cube A first and then Cube B after in order to use Linked Measure Group correctly .since while processing only cube B I got error as

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

Hope to know from the one who knows better in this field.Your small help will be really appreciated.

Thanks,

Anil Maharjan

Answer 1

Hi Anil,

The error shows that the linked measure group metadata no longer matches that of the source measure group. It is not recommand to delete the irrelevant measures when create a linked measure group. We can set the "Visible" property to "False" to hide this measure. Here is an article for your reference, please see:
http://bizintnz.blogspot.com/2009/10/ouch-nasty-ssas-linked-object-error.html

Regards,
Bin Long 

---

Bin Long

TechNet Community Support

Answer 2

Hello Bin,

Thanks for the response that means we cannot delete the Measure's from the Linked Measure Group then.

Also, do we need to process the Cube A first and then Cube B after in order to use Linked Measure Group correctly or simple we can process Cube B only. since while processing only cube B I got error as

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

Thanks ,

Anil Maharjan