User manual BUSINESS OBJECTS OLAP INTELLIGENCE XI

[. . . ] OLAP Intelligence XI User's Guide OLAP Intelligence XI 1 Patents Business Objects owns the following U. S. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Navigate to the folder containing the OLAP report. Click the OLAP report you want to view. 130 OLAP Intelligence Help Viewing an OLAP Report Understanding the Worksheet 7 Understanding the Worksheet The picture below shows an example of the Worksheet display. In this example, Products is the row dimension and Measures is the column dimension. The Products dimension is made up of a hierarchy of many members, but the members selected for display in this example are the top-level total, All Products, and the group totals, Bakery, Frozen Goods, and so on. Here All Products is the parent member to the child members lower down the hierarchy. "Selecting row and column members" on page 140 shows you how to change the selected members. The dimensions that are not used as rows or columns are displayed at the bottom of the window: Version, Week and Year in this example. Whereas you can see multiple members of the row and column dimensions at once, you move through the members in the slice dimensions one at a time to fix a different slice of the data in the Worksheet. For example, if Week is a slice dimension, as here, you can select any single week, or the total, as the active member. Here the total All Weeks has been selected. The arrangement of the rows, columns, slices, and the selected members is known as a Worksheet view. When you save an OLAP report, the Worksheet view is also saved. The next time you open the report, the Worksheet looks the same as when you saved it. This also applies to a view that has been set up from within Microsoft Excel, using the OLAP Intelligence Add-In. To see a different view of the data (for instance, to view Products against Week rather than Products against Measures), you can swap two dimensions. This is also known as "reorienting" or "pivoting" the Worksheet. See "Swapping dimensions" on page 138. OLAP Intelligence Help 131 7 Viewing an OLAP Report Setting parameters when an OLAP report loads You can also display more than one dimension as a row or column; for example, you can display the data for the Measures against Year to show data for both years. This is known as "stacking dimensions". See "Stacking dimensions" on page 139. Setting parameters when an OLAP report loads When you load an OLAP report, you may have to set values for various parameters. The Set Parameters dialog box appears only if the OLAP report is designed so you can specify parameters. The Set Parameters dialog box may look something like this: The image shows four parameters that you can set. Click OK once you have provided values for each parameter. There are four different types of parameters you can specify from the Set Parameters dialog box. [. . . ] To check that the server details are valid, click Test. If the connection is successful, click Update. The OLAP report now uses the new data source. 254 OLAP Intelligence User's Guide Business Objects Information Resources appendix A Documentation and information services Documentation and information services Business Objects offers a full documentation set covering its products and their deployment. Additional support and services are also available to help maximize the return on your business intelligence investment. [. . . ]