topic Visual analytics report was moved and renamed, how do I update my Excel sheet in Microsoft Integration with SAS

Visual analytics report was moved and renamed, how do I update my Excel sheet

ThdB — Fri, 15 Mar 2019 13:33:40 GMT

I have an Excel sheet that uses the results of a very large (many tables) Visual Analytics report.

Recently the name and the location of the V.A. report has changed.

Does anyone know if it is possible to update the name and location of the report in my Excel sheet?

Re: Visual analytics report was moved and renamed, how do I update my Excel sheet

VDD — Fri, 15 Mar 2019 13:55:30 GMT

this is not really a SAS question. You can open the workbook save it with another name with out updating the links.

then do a mass change to the links. something like this

C:\mystuff\longpath\file1

F:\theirstuff\longpath\file1

Re: Visual analytics report was moved and renamed, how do I update my Excel sheet

ThdB — Fri, 15 Mar 2019 14:13:36 GMT

Maybe I wasn't specific enough, but when I try to refresh the SAS content in my Excel sheet I get the error from the SAS add-in:

The SAS report was not found in the repository.

Verify that that the report still exists, and you have permission to execute it.

I get this error because the SAS Content was moved to a different location.

My question is: Can I update the properties of the SAS content in my Excel sheet to the new SAS report location.

Re: Visual analytics report was moved and renamed, how do I update my Excel sheet

fifthand57th — Mon, 18 Mar 2019 18:38:01 GMT

@ThdB Use the Migration Wizard. The SAS Add-in Migration Wizard (MigrationWizard.exe) is located in the SAS Add-in install directory. Search for MigrationWizard.exe on your computer. The Migration Wizard will allow you to remap the SAS metadata objects in a workbook.

Here's a SAS Enterprise Guide migration wizard tutorial: https://video.sas.com/detail/videos/working-with-sas-enterprise-guide/video/4414780853001/use-the-migration-wizard?autoStart=true

The SAS Add-in version is slightly different but this video will give you an overview, if needed.

Re: Visual analytics report was moved and renamed, how do I update my Excel sheet

ThdB — Tue, 19 Mar 2019 09:37:03 GMT

this works like a charm.

Thx!!!