Skip to Content
author's profile photo Former Member
Former Member

BO Webi: How to populate a variable with the set of static values for Graph

Hi All,

I have the data: Order number, Order Date, processing time coming from the SAP Bex query in the below format:

Order No Order Date Processing time (Days)

1 Jan-2011 4

2 Jan-2011 5

3 Feb-2011 6

In BO webi report, I have to report the number of orders which were processed in <1day, <2days, <3days,...<10days in a graphical view. i.e., X-Axis: <1day, <2days, <3days,...<10days(10 static buckets for the processing days)

Y-Axis: Number of Orders.

The graphical output should be like below:

X-Axis: <1day, <2days, <3days,<4days,<5days,<6days,<7days,<8days,<9days,<10days

Y-Axis: 0, 0,0,0,1,2,3,3,3,3 (count(Order No)) (Cumulative count)

I am able to calculate the number of orders individually for each of the 10 buckets. But the problem i am facing is that I am not able to hold the 10 static bucket values in a variable to use it for the x-axis in the Graph, as these 10 static bucket values are not coming from the backend source.

I would like to know if there is way to populate a variable(to use it for the X-Axis in the graph) with the set of 10 static values.

Any help would be highly appreciated.

Thanks,

Leela

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 12:56 PM

    Hi ,

    I think we can use the variable as X-axis in chart.. but Variable Qulaification should be Dimension.

    can you try this?.

    Using efasion universe

    1) Select month and Sold at (unit price) , then run the query

    2) create the variable V_Month ==If [Month]=1 Then "Month1" Else "Month2" (Note = Variable Qulaification should be Dimension)

    3) Create the variable V_Sum= sum (Sold at (unit price))

    4) create another variable V_Cumulative_Sum==[V_Sum]+Previous([V_Sum])

    Now add V_Month and V_Cumulative_Sum in table , then convert to chart.. now you can add the variable V_Month as X-axis of the chart.

    Hope this will help:)

    Thanks

    Ponnarasu K

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am sorry for the late reply..

      With this approach, the buckets will be shown only for the available orders with the processing time. But my requirement was to show all the buckets irrespective of the data and display 0 for the non available records..

      Thanks,

      Leela

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.