Skip to Content
0
Former Member
Nov 29, 2011 at 02:49 PM

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

942 Views

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