I have been dealing with this error in BI Studio under different circumstances. One way to create it, also the way that frustrates me most, is copying and pasting. I can copy and paste data sources, data source views from one project to another without any problem; but when it comes to cubes and dimensions, I consistently get the following error:
Error loading 'MyDimension.dim' : Deserialization failed: The method or operation is not implemented.
Would anyone be kind enough to let me know whether you can copy any cubes and dimenions from one project to another on your system?
Thanks,
hz
You can use the "Add existing item" option (right click on your BI project node in Visual Studio and use Add -> Exiting Item. Then select the .ds, .dsv, .dim, .cube files you want to add; they will be copied to your project.
I just tried this and I don't get the error you have, do you happen to have mixed builds ? (like a SQL Server community preview build combined with the RTM build ?) Also, do you have Visual Studio 2005 RTM ? (or a Beta ?); the RTM build is needed.
If you have Visual Studio 2005 RTM and SQL Server 2005 RTM, then I suggest to re-install SQL Server Tools, if it still doesn't work, try re-installing both of them. The error you are getting suggests an installtion problem.
Adrian.
|||Thanks, Adrian.
I have VS standard version and SQL 2005 Evaluation version, which I assume is the same as Enterprise Ver.
I have noticed that if I click the error in the Error List window, the code window will open. Then, if I change anything of the code (e.g. add a meaningless space somewhere) and save it, the error disappears and everything works perfectly. Very puzzling, but I can live with this minor annoyance.
|||Check the SQL Reporting Services Service... the account used to "Logon" might be expired. Once I started this service the error went away (my account this service was running under the password was expired).
No comments:
Post a Comment