Accessing Data and Data Analysis
Introduction to Accessing Data with BusinessObjects
6. Click Run.
BusinessObjects makes the data from the spreadsheet available in your
X To build a data provider inside an existing document
1. Click New Data Provider on the Data menu.
2. Follow the wizard to select the type of data provider you want.
3. Build then run the data provider.
• BusinessObjects retrieves the data, making it available in the document.
If you want to see the new data as soon as BusinessObjects has retrieved it, use
the Table, Crosstab or Chart commands on the Insert menu, then follow the
wizard to access the data you want.
Editing data providers
Editing a data provider means changing its definition in order to bring new or
different data to the document you are working on. It’s often quicker and easier
to edit a data provider than to build a new one.
Adding regional information to an existing document
You’re working in a document with sales figures by year, but you need some
regional information to complete the picture. Rather than building a new query,
which means creaing multiple data providers in the same document, you can
simply add result objects to the existing data provider. To do this:
1. Click Edit Data Provider on the Data menu.
In the Query Panel, add the objects you want (for example Region, City) to the
Result Objects box. You do this by double-clicking each object’s icon in the
Classes and Objects list.
2. Click Run.
BusinessObjects returns the new data to the report, and, provided that your data
is displayed in a table, the new columns automatically appear.
Other reasons for editing a data provider include:
• You want to restrict the volume of data returned by setting conditions or
maximum number of rows.