Getting Data from Essbase 9.3.1
Hi, I'm trying to get Data from an Essbase database into a SSRS 2008 report. Connection seems to be ok for getting the meta data of the Essbase cube into the Query Designer. But if I add one measure into the right lower box after having specified one member for each dimension in the right upper box then I get the following error: TITLE: Microsoft SQL Server Report Builder ------------------------------ The server sent an unrecognizable response. ------------------------------ ADDITIONAL INFORMATION: Unable to format XML value according to declared type. (Microsoft.ReportingServices.DataExtensions.XmlaClient) ------------------------------ Die Eingabezeichenfolge hat das falsche Format. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ The report can be saved but I can't get data. I don't think it's a problem of the XMLA code because I tested the XMLA code with a self created report tool which uses the assembly of SQL Server for Essbase access - funny, isn't it?! SELECT { [Kundenrabatt Brutto], [Umsatz Brutto] } ON COLUMNS,{ [Jahr 2009], [Jahr 2008] } ON ROWS FROM TUL.TUL WHERE ([Ist], [KONZERN], [EUR], [Abt. 001]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING The SQL Server 2008 Standard x64 runs with most recent updates. Any idea how to solve this problem? Thanks in advance. Regards, Alex
April 29th, 2010 2:17pm

Si, hay muchas dudas, como realizaste la conexion de Essbase y .net
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2011 6:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics