ssasbusiness-intelligencecubeperformancepointdashboard-designer

Propagate the changes made in Analysis Service's Cube in Performance Point Dashboards


I have several performance point dashboards in SharePoint 2010 made from several cubes containing several measures and dimensions. Earlier, the measures and dimensions had too long name. Now their names has been shortened. After the changes has been made in the cubes, rather than seeing the new changes, I am seeing errors ever where. I tested the connections for every cube in Dashboard Designers and they looks fine. I closed and re-opened the Dashboard Designer but it did not help. Redoing everything again will be long and hectic job. Please let me know of any workarounds you have.

Thank you

Merin


Solution

  • Save your worksapce your dev machine as a workspace file (.ddwx). You can do that by selecting File --> Save As in the Dashboard Designer. The .ddwx file is an XML file that you can open in Notepad. Search and replace old dimension names with new ones. Open up the file in Dashboard Designer and re-publish.