How to use request variable in rpd

Question

Hi,

I have a requirement:

In my RPD, I have a metric Act amount. that should be calculated based on 2 metrices in rpd (Loc Amount( local currency amount) and other is Doc amount (Document currency amount).

I have a dashboard prompt for currency, if user chooses Doc currency in prompt, then Act amount should use Doc Amount column ,  if user chooses Loc currency in prompt, then Act amount should use Loc Amount column.

How to pass user selected currency from prompt to RPD to achieve this?

How/can we use request variable?

Thanks,

Anilesh

Joel Acha · Answer

Hi Anilesh

You'll need to use a request variable if you need to access it in your repository.

Also, you'll need to create a session variable in your repository with the same name as your request variable. The dashboard prompt sets the value for your request variable and in turn it overwrites the value of the session variable with the same name in the repository.

You can then reference your session variable in your logical column formula within your repository and it's value will be overwritten by your request variable value.

See a bit of information about request variables here:

Creating Analyses

Thomas Dodds · Answer

You could do it by setting a session variable, but not a repository variable ... this is how currency selection and exchange rate is done.

Here's some example of how it has been done:

INDEXCOL(

CASE  VALUEOF(NQ_SESSION."PREFERRED_CURRENCY")

WHEN 'USD' THEN 0

WHEN 'EUR' THEN 1

WHEN 'AUD' THEN 2 END,

"01 - Sample App Data (ORCL)"."Catalog"."BISAMPLE"."F19 Rev. (Converted)"."Revenue_Usd",

"01 - Sample App Data (ORCL)"."Catalog"."BISAMPLE"."F19 Rev. (Converted)"."Revenue_Eur",

"01 - Sample App Data (ORCL)"."Catalog"."BISAMPLE"."F19 Rev. (Converted)"."Revenue_Aud"

)

OBIEE - IndexCol Function - Handle hierarchy Level security [Gerardnico]

3238275 · Answer

H Joel,

I am building the formula in RPD. Is it possible to access presentation variable inside RPD. Or any other way to acceess?

Thanks,
Anilesh