Essbase (beta) measures all null

Anonymous · ‎05-22-2019

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.

Anonymous · ‎06-06-2019

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.