I am pulling data form an MDS server into excel using the 2012 SQL server add-in. I am running into a problem where I am referencing the data in the tables for other analytics in my excel document. When we open up a new version in MDS the excel table does not point to the newest version. Instead, it will always point to the same version.
Is there anyway to easily update this to point to the newer version when older versions get closed?
Rebuilding the query proves problematic because creating a new table breaks all the formula references to the table in the rest of my excel document.
Any help would be appreciated
I am using Office 2013 365 and Windows 8.1
I think you have to use the View from Excel (connect to MDS View from Excel with regular Db connection). Have view created with Version Flag not Version Number. Create this flag in Version Management (double click on "Flag" to edit the cell) then use this Flag in View definition
This way you can assign the same flag to new Version numbers and keep the same View.
Ok I am not quite sure I follow. By regular Db connection you mean through the master data add-in right? I do not see anything called version management. Is the flag you are referring to the string at the top of the table that is created. Ie something like this:
MDS Connection: MDS(http://SERVER) Model: ModelName Version: VersionName Entity: Table Retrieved: 12/10/2013 10:49:08 AM
I have tried to change this cell but it does not appear to change the data.
I am talking about the "Data" tab in Excel. (http://office.microsoft.com/en-us/excel-help/connect-a-sql-server-database-to-your-workbook-HA103791059.aspx) then attach to a View that you create in MDS under "Integration manager" -> "Create Views" ...
Create View is covered at http://technet.microsoft.com/en-us/library/jj819795.aspx (only in Step 7 don't choose Version_1, choose the Version Flag that you would have created earlier :) in Version Manager section of MDS. This would give you a Version in depended View that you could link to from Excel.
- Bearbeitet EthernetIP Dienstag, 10. Dezember 2013 21:48