Restore Cube Database onto another server

• Laura Schmalzbauer

  SSCommitted

  Points: 1672

  More actions

  March 17, 2009 at 2:16 pm

  #207139

  I am trying to restore a cube from Analysis Services from a production box onto a QA box. However, when I do so, after about an hour, I get the following set of errors:

  MdxScript(HPOLSS) (8,5) The "[FORMAT]" function does not exist

  MdxScript(HPOLSS) (11,5) The "[FORMAT]" function does not exist

  MdxScript(HPOLSS) (14,5) The "[FORMAT]" function does not exist

  I have tried looking up a way to fix the error but have had no luck. Any suggestions would be useful.

  Thanks.

• JamieX

  Hall of Fame

  Points: 3763

  More actions

  March 19, 2009 at 10:32 am

  #962890

  Did you get this fixed? Make sure all the same DLL Files are located in the bin dir of the OLAP install folder..

  Default:

  "C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin\"

  -- compare working install against server you cannot restore to.

• Laura Schmalzbauer

  SSCommitted

  Points: 1672

  More actions

  March 23, 2009 at 7:52 am

  #964423

  Unfortunately, this has not been fixed. All the DLL's are located in the proper binn folder. Still at a loss as to why I'm getting this error.