Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

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
393 views