Skip to Content
Author's profile photo Arijit Das

A custom Pie Chart add-on for BusinessObjects Dashboards 4.0 SP3 or higher

Here is another interesting add-on for BusinessObjects Dashboards 4.0 – a custom pie chart. In my working experience, many times, I did face the requirement of a doughnut chart and exploding a pie wedge while drill-down. So, I have created an add-on for the same in flex with dashboards sdk which I am sharing here.

Features:

General Tab

In this tab, there are options to

  • bind the labels and values of the pie chart to excel range.
  • insert selected label and value to excel.

Note:
  • Records with blank values in label or data are ignored.
  • If no item is selected, NaN is inserted as value.
  • Once selected, an item can be deselected by clicking the exploded wedge.

Behavior Tab

In this tab, there are options for:

  • Dynamic visibility: Setup dynamic visibility of the component.
  • Negative value handling: Show negative values as absolute in pie chart or do not show the record at all.
  • Top N and Others: It is possible to show top N records and group other records as ‘Others’ in the chart.

Note:

If show negative values as absolute is selected, negative data is displayed as positive in chart, though, data is inserted as negative while drill-down.

Appearance Tab

In this tab, there are options to:

  • vary inner radius to create a doughnut chart.
  • bind colors of the pie wedges to an excel cell range.
  • show or hide border.
  • select border color.
  • select background color.
  • select position and font of the legend.

Note:
  • Wedge colors can be a flex-supported color name or a valid hex color code. If it is not, then black will be selected.
  • It is recommended to select a color range larger than or equal to the range of labels. Otherwise the colors will be repeated.

How does it look like in canvas

Without drill-down

After drill-down

Showing top 3 and Others

A Doughnut Chart

Showing data on mouse hover

Custom background and border color

Download

The full flex project along with the add-on(xlx) file is available here for download.

For more interesting add-ons, visit the wiki page SAP BusinessObjects Dashboards 4.0 Add-On Gallery.

Happy dashboarding 🙂

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good One Arijith.

      Author's profile photo Arijit Das
      Arijit Das
      Blog Post Author

      Thanks Mallik

      Author's profile photo Former Member
      Former Member

      Hi Arijith

      Thanks for the article Airijit.... 🙂

      Are these add-ons in the gallery free?

      I read the terms and conditions there. But.... 😕 😕 😕 .

      Can I download it for free for usage in my organization(Bank)?

      Thanks

      Sandeep

      Author's profile photo Arijit Das
      Arijit Das
      Blog Post Author

      Hi Sandeep,

      All of these are absolutely free. These are samples showing how to create custom components for dashboard. You can use it, however, no support will be provided by SAP.

      Regards,

      Arijit

      Author's profile photo Former Member
      Former Member

      Thanks Arijit.

      Author's profile photo Former Member
      Former Member

      I am trying to use the hex color code but I can't get it to work. Are all codes available for use?

      Author's profile photo Arijit Das
      Arijit Das
      Blog Post Author

      Please try using the 24 bit color code like: 0x000000, 0xFFFFFF. It should work.

      Author's profile photo Former Member
      Former Member

      great!! thank you

      Author's profile photo Former Member
      Former Member

      hi Arijit,

      How to install add-ons after downloading on server/developer's machine? so that it will appear in dashboard designer tool.

      Regards,

      Ravish

      Author's profile photo Arijit Das
      Arijit Das
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Thanks Arijit