Skip to Content

Pie Chart with measures only in Webi?

I am trying to create a pie chart in Webi with a set of measures but cannot. Has anyone done this before? Using Webi version 14.0.2

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2014 at 03:11 PM

    Hi Kelly,

    As per documentation we must have one dimenssion to create an pie chart.

    We cannot create pie chart with all the measure values, however you can use following trick to achive your goal.

    1. Create report with all measure values.

    2. Create new varaible as mention below.

    3. The Final Output :

    Hope this trick will help you to achive the final goal.

    Regards,

    Veer


    Pie Chart_1.jpg (84.6 kB)
    Pie Chart_2.jpg (13.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2012 at 01:36 PM

    Hi Kelly,

    There should be atleast one dimension object in order to create a chart.This is a pre requisite.

    Can you brief your requirement.

    Regards,

    Mani

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2012 at 08:25 AM

    Hi Kelly,

    I think you would require one Dimension. And if the measure is not any aggregated value, you can try to define it as a Dimension and then check.

    Thanks,

    Kirthi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2012 at 12:42 PM

    Kelly,

    You can define One measure Value as dimension on report Level and check its Feasibility at your level.

    Once defined as dimension you can take the measure in the Pie chart, however still it has its own limitation and will work on case to case basis.

    Cheers !!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 02, 2014 at 10:12 AM

    Hi Kelly,

    Please refer the SAP note: http://scn.sap.com/thread/3226478. In which i have shown the pie chart with only measure object. It is necessary to have the dimension object to create a pie chart if you will see the properties of the pie chart, it means in somehow we need to arrange all our measure into single measure object and have dummy dimension object.

    Please refere the note. Feel free to post your reply if any issue.

    Regards,

    Mantu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2015 at 10:33 AM

    Yes. In above i have shown same only.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2016 at 10:42 AM

    did u able to get half pie chart (including total)?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2016 at 11:54 AM

    I have got a solution for the scenario in one of my project.

    I had 5 measures in the report and I was suppose to display the cumulative value of the 5 measures in a Pie Chart.

    As my source was Bex so I made a structure in the Bex Query and finally got the cumulative value of all 5 measures in a form of crosstab in webi.

    Then I have created a new variable and get all 5 cumulative values to a single column and used in Pie chart.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.