Skip to main content
Microsoft Idea

Power BI

Needs Votes

Hyperion Essbase - specify alternative "Measures" dimension name in the connection settings

Vote (1) Share
Stephen's profile image

Stephen on 07 Jul 2020 06:12:02

Certain Hyperion Essbase Databases do not have their measures on a Measures dimension.

For example a General Ledger (GL) cube may have the measures on the Account dimension.

Because the Essbase connector assumes there will always be a Measures dimension, it attempts to create a Member on the Measures Dimension in order to analyse the data held in the other dimensions. This causes an exception, because there is no Measures dimension.

Being able to specify an alternative dimension name to create the member on would allow inspection to proceed.