BusinessObjects Board

Data grow issue in WebService con

other Xcelsius - Crystal Dashboard Design
#1

Hi

I am using BO 4.0 and Dashboard design. I have a monthly crosstab report which i am using to build a scorecard in dashboard.

My data is growing from left to right. example



          Jan   Feb  March
North   3       4    5
South  3       6    5

so If i make a webservice based in this data only, it works…

how do I make this dynamic so that it takes care of the next month data which is April data… I mean as the report is scheduled to run every month… the next month data will come… how do i make my dashboard data grow automatically.

Thanks

rajx72 (BOB member since 2006-08-02)

Pivot Tables
#2

I THINK your best bet is to work the webi report so that you have a column for each month, with empty values for those months for which you don’t have data yet.

That way you won’t have to worry about adjusting for each month.

Good luck.

-tkt

theknowtank (BOB member since 2011-04-20)

#3

HI

Thanks… it is one way… but what if I am in January… and how will i put the dummy data for 11 months…in Webi

Thanks

rajx72 (BOB member since 2006-08-02)

#4

Don’t create a pivot table. Create a different variable for each month, and write the formulas so that the correct values end up in each month, and put all 12 variables in a standard horizontal table along with your “North/South” field.

-tkt

theknowtank (BOB member since 2011-04-20)