Hi all, I would like to use a substitution variable from Essbase within our OAC dashboard. However, I can not get the substitution variable to pull through correctly. I have tried two separate options. * Using the default Repository Variables that were created on import and pulling in the variable with The VALUEOF expression * Creating a new repository variable and initialization block. I believe I am missing a step on each. Specifically what to put in as the Default Initialization String to refresh the variable. If anyone has the correct steps please let me know.

Oracle Communities

Oracle Analytics and AI

Child Item

Extracting Substitution Variables from cube using RPD

Hi all,

I would like to use a substitution variable from Essbase within our OAC dashboard. However, I can not get the substitution variable to pull through correctly. I have tried two separate options.

Using the default Repository Variables that were created on import and pulling in the variable with The VALUEOF expression
Creating a new repository variable and initialization block.

I believe I am missing a step on each. Specifically what to put in as the Default Initialization String to refresh the variable.

If anyone has the correct steps please let me know.

{F95FDBDD-28FC-445D-9683-220CCE6E5FBC}.png

Find more posts tagged with

OBIEE

OAC

Accepted answers

Wayne Van Sluys

When you import the cube into the RPD the SubVars for that cube will show up as Dynamic Variables

I usually create a separate database and connection pool with imported cubes just for SubVars and have the Service Account get the values. then delete the variables for the cubes that are for the dashboards since that connection pool is using sso.

All comments

Mallikarjuna Kuppauru-Oracle

Hi @Conor Murnane

can you refer our product documentation -

Use Substitution Variables

Regards,

Arjun

Conor Murnane

Hi Thank you but - This is not what I am looking for. I am looking for any documentation or steps on how to pull a substitution variable from Essbase into OAC while using the RPD as middle layer

Wayne Van Sluys

Conor Murnane

@Wayne Van Sluys Wayne! That worked.

Thank you,

Conor

Bhaskar Konar

Very helpful information.

Thank you very much @Wayne Van Sluys! Appreciate all your help.