topic Re: Essbase (beta) measures all null in Report Server

Essbase (beta) measures all null

Anonymous — Wed, 22 May 2019 14:52:39 GMT

I'm using a connection string formatted like so: http://[NAME]:[PORT]/aps/XMLA and can successfully connect to our Essbase server.

I can view cubes within the server as well as each cube's dimensions and measures.

Dimension members return successfully; I can display them in visuals on the canvas.

However, all measures always show as null. This is true in the Get Data dialogue, in the query editor, wherever.

Does anyone have any idea why this is occurring? Or has anyone successfully used essbase cubes in the Report Server version of PBI Desktop? If so, I'd like to see all the details of the connection.

The Essbase admin says we're on version 11.1.2.4.

Re: Essbase (beta) measures all null

Anonymous — Thu, 06 Jun 2019 15:46:53 GMT

Hi I am not an IT person but played a lot with the Essbase connector. Had the Null issue on my side. The solution was to check via smartview what is the minimum set of filters returning a value from Essbase and then trying to replicate it via connector. It was loads of trial and error but worked in the end.

Re: Essbase (beta) measures all null

Anonymous — Thu, 06 Jun 2019 15:49:26 GMT

I'm sorry, can you elaborate? I'm not familiar with Essbase at all.