Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculate with Dashboard Prompt (Presentation Variable)

661548Oct 14 2008 — edited Oct 16 2008

hello, i am a new BI user and i have a question. +(sorry, my english is not so good)+

i have create a dashboard prompt for a year number. i placed 2 reports on dashboard (Year / LastYear). the first with the value of the prompt,
the second must be calculated the value of the prompt -1. (Year = 2008 -1 = 2007).

the presentation variable is @{VAR_JAHR}, Prompt Value is 2008

i have create a controllfield, in formular editor. the formula *@{VAR_JAHR} -1* is 2007, that is ok.

in the second report i set the filter at the presentation variable @{VAR_JAHR} -1 or @{VAR_JAHR-1} ..., but this is a error.

can everyone help me?

thanks

oliver

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2008

Added on Oct 14 2008

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #obiee, #prompt, #report

14 comments

1,546 views