Hi, I am working with the RTM version of SQL2012 and succesfully created a geogroaphy model. I then created an country entity and loaded it useng the excell add-in. In a second step I created a continent entity which is referenced from the country entity. Al this behaves as expected in the web UI. Both entities can viewed and edited.
When I connect from Excel again to the model, I can load the countries without any problem. When I try the same for the continents entity, the spreadsheet hangs with the message "retrieving member count".
I also activated the logging, but that does not give much information. Has anybody an idea what goes wrong?
I think it's an Excel related issue. I had the same stuff when using Excel that was installed on the virtual server hosting MDS. Then I installed the add-in onto my local machine and it works as expected.
So I don't know the reason but I haven't changed anything in MDS. Hmm. Just checked: are you using 64bit Excel? On the server we have 64 bit but locally I've got 32bit. If you also use 64bit give it a try with the 32bit Excel version and let me know whether it works.
I did some additional testing with another PC and there the add-in worked without flaws.
On the failing system I did an uninstall/reinstall of Excel, but it turns out this does not remove the add-in.
I have visual studio beta products on this system, including net 4.5 code, so I Suspect Ovidio's answer might be the correct on.
Thanks to all for the suggestions.
PS I als have installed the RTM version of MDS in another environment and did quite some work with it and have had no further issues with the add-in.