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

10|10000 characters needed characters exceeded

### Related questions

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

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