Show percentages (%s) in Financial Reporting Charts


I was working with a client where they had a requirement to show charts.

They wanted a bar chart which shows values as shown below.


If you have worked on Financial reporting charts, you know that there is less option to customize it.
The issue with BAR chart is it always shows cumulative values only.
i.e 43+80 =123 and 43+80+16=139

So to get only the segment value (not cumulative values) 
  • Insert a combo chart (line and bar chart)
  • Change the Line Style to None
  • Change the Line Width to 0
  • Change the Line Marker Style to None
  • Change the Marker Size to 0
Now the hard part was to get the %s, (43%, 16%) for that I had to export the report to my system and edit the .des file.
  • Open .des file in a editor
  • Search for OBJECT_WIDTH in <CHARTOBJECT
  • After OBJECT_WIDTH add OTHERPROPERTIES=”LeftFormat=(FLOAT, ‘%d%’)”
e.g. OBJECT_WIDTH=”8460″ OTHERPROPERTIES=”LeftFormat=(FLOAT, ‘%d%’)”

There you go…..the chart is ready.
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Show percentages (%s) in Financial Reporting Charts