Power BI
NewHyperion Essbase - specify alternative "Measures" dimension name in the connection settings
Vote
(1)
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.