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!

Formatting of measures based on a particular scenario

734923Dec 3 2009 — edited Dec 3 2009

Hi,

I have created a pivot report on which measures are on side labels (rows) and scenarios (having values Actual, Budget, Var, Var%, LTD Actual, LTD Budget, LTD Var, LTD Var%) in columns.
Rest dimension members are excluded from pivot and managed by dashboard prompts.
Var, Var%, LTD Var and LTD Var% are computed items on pivot based on scenario column.

Report is working fine but i am facing problem in adding currency symbol ($) as prefix with values of Actual, Budget, Var, LTD Actual, LTD Budget, LTD Var and '%' as a suffix with values of Var% and LTD Var%.

How can i do different formatting of the same measure according to different scenario values.

Please suggest.

Thanks in advance.

Regards,
S Anand

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2009

Added on Dec 3 2009

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

1 comment

405 views