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. [. . . ] In the DHTML Interactive Viewer, set the parameter value by typing the connection details in the Parameter Value cell. Each element must be separated by a comma, but you only need to specify the elements that have changed since the 132 OLAP Intelligence Help Viewing an OLAP Report Executing an action 7 parameter was designed. If the OLAP report was built around a cube whose name was later changed, you only need to specify the new name of the cube (provided none of the other elements have changed). Member Parameters of type Member are used to specify individual members from a dimension. Set the parameter by clicking the ellipsis button in the Parameter Value cell. Select the member using the Member Selector. Memberset Parameters of type Memberset are used to specify column and row dimension members. Set the parameter by clicking the ellipsis button in the Parameter Value cell. Use the Member Selector to select the members that you want using the Member Selector. Page Parameters of type Page specify the opening page of the OLAP report. Enter the number of the page you wish to view next to the parameter description. Executing an action Actions extend the functionality of an OLAP report in a number of ways. Actions can: · · · · · · · · · · launch other OLAP reports or Crystal reports from your current OLAP report. dimension headings members in a dimension data cells Analysis Buttons You can launch actions from these places: OLAP Intelligence Help 133 7 Viewing an OLAP Report Using the data analysis features If actions are available in an OLAP report, the person who designed the report should provide details of these actions. To execute an action from the Worksheet Right-click the dimension, member, or cell from which to execute the action. When viewing an OLAP report from a web browser, clicking Actions opens a new browser. This contains the available actions for that member. Using the data analysis features OLAP Intelligence enables you to carry out mathematical analyses of the data in your Worksheet view. To select an analysis, select a row or column member on the Worksheet and click the Calculation button to display the Calculated Members dialog box, or right-click a row or column member on the Worksheet, point to Data Analysis, and click one of the following: Add Calculation Edit Calculation Create a calculated member using the Data Analysis Expert. This option is only available for calculated members created using the Data Analysis Expert. This option is only available for calculated members created using the Data Analysis Expert. Provides a summary of the statistics for the row or column. Remove Calculation Summary Statistics Best Fitting Curve Analyze the values in a selected row or column. Shows the properties of the best fitting curve running through those points. These tools are described in the sections "Getting a statistical summary" on page 135 and "Finding a best fitting curve" on page 136. For more detailed information about analyzing your data and using calculated members, see Chapter 12: Adding Calculated Members. 134 OLAP Intelligence Help Viewing an OLAP Report Using the data analysis features 7 Getting a statistical summary The Summary Statistics tool allows you to quickly explore and check your data. If you find something in your data that looks interesting, you may want to perform a simple analysis of the data before you do anything else. Point to Data Analysis on the shortcut menu and click Summary Statistics. [. . . ] To delete a saved view In the Organize area in the CMC, select Objects. Click Delete. Changing the cube displayed An OLAP report is usually built around a specific cube. It is, however, possible to change the cube that is used by a published OLAP report. To change the cube in a published OLAP report In the Organize area in the CMC, select Objects. [. . . ]