Tabular Annotation Workaround
Note: This feature is not in the latest release. You need release 1.6.2 to use this feature.
After upgrading to SQL Server 2012 SP1 SSDT, some users have complained about receiving an error that prevents them from opening the .bim file in a Tabular model:
An error occurred while opening the model on the workspace database. Reason: ReadElementContentAs() methods cannot be called on an element that has child elements.
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox(Boolean newProject, Boolean& isRefreshNeeded, Boolean& isImpersonationChanged, Boolean& saveRequired, List`1& truncatedTables, Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
at Microsoft.AnalysisServices.VSHost.Integration.EditorFactory.CreateEditorInstance(UInt32 grfCreateDoc, String pszMkDocument, String pszPhysicalView, IVsHierarchy pvHier, UInt32 itemid, IntPtr punkDocDataExisting, IntPtr& ppunkDocView, IntPtr& ppunkDocData, String& pbstrEditorCaption, Guid& pguidCmdUI, Int32& pgrfCDW)
This problem is a bug in SSDT in that it does not properly parse annotations created by BIDS Helper, and it has been reported to Microsoft here
. If you are experiencing this issue, please vote for it on Connect to raise it's visiblity. Until Microsoft fixes the problem, the BIDS Helper team has created a workaround utility which changes the storage format for BIDS Helper annotations.
If you are experiencing this ReadElementContentAs() error, then consider using this BIDS Helper workaround utility. With the .bim file closed, right click on the .bim file and select Tabular Annotation Workaround...
This feature will popup a confirmation dialog. Read it carefully, especially the note about every developer on your team upgrading to the latest version of BIDS Helper.