Substitution variable from Essbase Cube is not populating in OBIEE 12.2.1.2 rpd

Question

Hi Team,

Customer is using OBIEE 12.2.1.2 and Essbase 11.1.2.2

When customer is importing Essbase cube in rpd then substitution variable of essbase cube also imported. But whenever they are trying to test the substitution variable at rpd,test result is showing nothing.

Screen shot:

https://orioniss.us.oracle.com/iss/faces/issviewer/home?context=SR&contextNum=3-14962206791&file=variable.JPG

Could you please suggest any doc/ article to investigate further on this?

Thank you!

[Deleted User] · Answer

Does the user opening the connection have sufficient rights? Just did a cube some minutes ago and it works like a charm.

PinakiB- Oracle-Oracle · Answer

Thanks for your update here Robert. But that tips & tricks were for OBIEE 11g & my customer is in OBIEE 12.2.1.2.0 version.

Robert Angel · Answer

Have you seen this => An Essbase OBIEE integration walk through with tips and tricks