Voyager MDX Error

[Former Member]

Hello,

We have just set up a server with BOE and SBOP Strategy Management. We've successfully registered the ODBO files and created a Voyager connection to SSM. (We know that because we can see the list of dimension names in the Infoview.

However, if we click on anything, we are getting this MDX error:

java.lang.RuntimeException: Failed to execute MDX query. Reason: returned server error (Returned E_FAIL (0x80004005) )

Have you run into this error and could you suggest how to correct it?

Thanks,

Bob

[Former Member]

Hi,

What OLAP data sourtce is 'SSM'?

Voyager only supports MSAS 2000/ 2005/2008, Essbase 7.0/7.1/ 9 and SAP BW 3.1/7.x.

If SSM is a differentb typ of OLAP Server, then you will not be able to use it within a Voyager Workspace.

Isabella

[I_MCA]

Voyager also supports "Business Objects Extended Analytics" as an OLAP provider. Unfortunately I have very limited experience of this and have not heard the term "SSM" be used in relation to this.

Three letter mnemonics are used to represent SAP systems. Is SSM an SAP system?

Regards

[Bob_McGlynn]

SSM stands for SAP Strategy Management and is a SAP product. It uses Netweaver Composition Environment for Web Services and has a OLAP engine.

Regards,

Bob

[former_member652504]

Hi.. I have faced encountered such errors before with Hyperion and SAP.

Please check if you are using the correct SP for the Voyager client.

Most likely E_FAIL errors indicate driver issues.

Hope this helps.