BusinessObjects Board

Fixing dynamic x-axis, making it static

other Xcelsius - Crystal Dashboard Design
#1

Hello,

I am reading component values from BIWS-Webi into dashboard. The problem i am facing is the x-axis values keeps changing every year. How to make it static so that i can show constant values every year.

For example there are six program names - A, B, C,D,E,F and for year 2011 webi will have values for A,B,C,D and for year 2010 webi will have values only for C and D. When i plot a bar chart with 2011 vs 2010, i see C and D values jumping in the A, B place. This is because there is no row that exists in webi for A and B. I need to display all A, B, C,D,E,F in the chart and where ever values are missing it should show zero or N/A.

Anyways to do it in the Xcelsius spreadsheet? I tried with nested if loop but xcelsius have some limitations in the number of nested loops.
Appreciate your help.

Thanks,
Arun

Arun.K :us: (BOB member since 2011-10-18)

#2

Why don’t you do it at report level by creating a combined query and show all the values of program though you don’t have data.

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

#3

Combined query works only if the database has a value for the program name. Since there is no value for the corresponding programs, it is not shown in the webi. Hence the same is not captured in the dashboard.

So the option (as far as i know) i guess is only to tweek in the spreadsheet and enter the value.

Any suggestions?
Arun

Arun.K :us: (BOB member since 2011-10-18)

#4

I’d still do it in Webi as Zaif said but would use extended syntax to break out the program names into separate columns:

Col 1
[My_Measure] where([Program Name]=“A”)

Col2
[My_Measure] where([Program Name]=“B”)

etc…

Format the column to be 0 when null should give you the results you need.

cdavies :uk: (BOB member since 2005-01-28)