SQL

Errors in the metadata manager+SSAS error

Here is one of the SSAS error you will face,

Error 12 An error occurred while parsing the 'StorageMode' element at line 1, column 8368 ('http://schemas.microsoft.com/analysisservices/2003/engine' namespace) under Load/ObjectDefinition/Dimension/StorageMode. 0 0 


Error 13 Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.SQLSERVER2008R2V\OLAP\Data\OLAP2.0.db\Fact Reseller Sales.5.dim.xml'. 0 0

Solution: 
  
  The issue is due to change in the dimensional data holds some conflicts on the existing measures data. 
  
In this case, 
   1. Go to the specified location and delete this file... reprocess the dimensions and deploy the cube. 
   2. Delete the dimension and recreate the dimension. Add it to the cube. 
   3.  Final option, delete the Analysis database and try to process and deploy the cube into the server. 
  
Cheers, 
Venkatesan Prabu .J 
Head, KaaShiv InfoTech, Chennai. 
http://www.kaashivinfotech.com/ 
Ebook Download
View all
Learn
View all
Membership not found