Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Server Name/Cube Name Changes and Excel

    We have a large user community that have created a number of MS EXCEL spreadsheets using MS OLAP Cubes as their input. Every month, once the cubes have been updated, the users can "refresh" their spreadsheets. These spreadsheets range from simple to complex, depending on the user's skill set and task to be performed.

    Here is the problem... We are in the process of moving the cubes to a new server and the cube names are changing due to new Naming Standards. What can we do to minimize the impact to our user community?

    Thank you all for your input

  2. #2
    Join Date
    Jun 2003

    Re: Server Name/Cube Name Changes and Excel

    Haven't tried this but it's worth at least testing I think:

    How about just creating a virtual cube that's linked to the "new" cube on the new server. If the virtual cube has the same name as the older version, the user should not see a difference.

    I don't know anything about performance issues though, you might need to test this first.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts