Essbase Substitution Variables are not showing any value after importing into OBIEE........

3410125

Essbase Substitution Variables come as dynamic repository variable in rpd.I am using OBIEE 12.2.1.2 and Essbase 11.1.2.2

[Deleted User]

You mean you can import them and they appear as metadata objects in the RPD but you get no values when you press "Test" for the SUB_VARxyz init block?

Does the user which user used in the connection pool have the rights to read the variables in the cube?

3410125

we are using user "Admin" to connect Essbase.

When I click on "Test" in init block section it is prompting "Empty result set".

[Deleted User]

I only had these in two cases

a) insufficient rights

b) incorrect essbase version used in the call interface (rpd settings)

3410125

When we are importing Essbase cube in rpd, it is showing that connection type as Essbase 9+. But after importing the cube in rpd, in database general tab it is showing database type as "Essbase 11.1.2.3.500". But we are using Essbase 11.1.2.2.

[Deleted User]

OK so DB type should not be higher than what you actually have. Go for "Essbase 11". The MDX-producing libraries are quite specifically 11.1.2.3.500 and above