BusinessObjects Board

Data change in Excel Automatically refresh Dashboard

other Xcelsius - Crystal Dashboard Design
#1

Hello There,

There is a requirement to use a Excel as a source from perticular location on app server, but every month data will be refreshed. When data refreshed in this Excel automatically dashboard should be refreshed/reflected.

This Requirement on Business Objects Dashboard 4.0

Thanks a ton in Advance.

Best Rgds
Shravan

shravan_bo :india: (BOB member since 2006-04-25)

#2

Create an XML map of your spreadsheet source. When the data changes, save normally to save spreadsheet. Then SAVE AS XML to update the XML map too.

Build your dashboard using an XML MAP connection. Provided the users remember to save the map, your dashboard will update.

Debbie

Debbie :uk: (BOB member since 2005-03-01)