Operation Manual

Creating and Updating OLAP Reports
Updating an OLAP report
19
374 Crystal Reports User’s Guide
Before updating your report, it is important to ensure that it is compatible with
the data. Some things to look for include:
• Removing dimensions contained in the report that are not in the cube.
• Removing fields referred to explicitly in the design of the report, such as a
formula.
Note: If a report contains subreports or grids, and the database used for them
have changed name or location, you must update each subreport or grid.
u
To update a cube location in an OLAP grid object
1. Select the grid by clicking on the border.
2. From the Database menu, click Set OLAP Cube Location.
Tip: You can also right-click the grid and select Set OLAP Cube Location.
The Confirm Command dialog box appears.
3. Click Yes.
The Set OLAP Cube Location dialog box appears.
4. Click Select.
The OLAP Connection Browser appears.
5. Browse your OLAP server for the cube you want to connect to.
If your server isn’t in the list, click Add Server. In the New Server dialog
box, provide the server information; then click OK.
6. Select the desired cube and click Open.
The Set OLAP Cube Location dialog box reappears.
7. Click OK.
If your report contains multiple OLAP grids that are based on the same
cube, the program prompts you to update the remaining grids to the new
location.
Finally, if the location of your report’s relational database is the same as the
location of your cube, you are prompted to change the location of the
relational database to match the new location of the cube. Making sure that
the location of the relational database and the OLAP cube match ensures that
your data remains synchronized. The program can change the location
automatically, or you can change it manually in the Set Datasource Location
dialog box. See the following section for more information about using the Set
Datasource Location dialog box.