locked
Getting Data from Essbase 9.3.1 RRS feed

  • Question

  • 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

     

     

    Thursday, April 29, 2010 11:17 AM

All replies

  • Si, hay muchas dudas, como realizaste la conexion de Essbase y .net

    Tuesday, April 5, 2011 10:18 PM