SAP BusinessObjects Web Intelligence User's Guide

1 PUBLIC. SAP BusinessObjects Business Intelligence Suite Document Version: Support Package 4 2018-11-15. SAP BusinessObjects Web Intelligence User's Guide 2018 SAP SE or an SAP affiliate company. All rights reserved. THE BEST RUN. Content 1 What's new, how and where to get help.. 12. Documentation for SAP BusinessObjects Web Intelligence .. 12. What's New in SP4.. 13. To access online help.. 17. To access the Web Intelligence Guide via the internet..17. 2 About Web Intelligence .. 19. Getting to know Web Intelligence and the BI Launch Pad.. 20. About the Web Intelligence interfaces.. 20. Application components.

2 26. Understanding the BI launch pad..27. Configuring Web Intelligence Rich Client.. 32. To install Web Intelligence Rich Client from the BI launch pad.. 32. To install Web Intelligence Rich Client from the SAP Software Download Center.. 33. Online help in a Web Intelligence Rich Client installation..34. Web Intelligence Rich Client processes..35. Connection modes.. 36. Connection modes in Web Intelligence Rich Client.. 43. To set the default universe for a document.. 44. To set viewing preferences.. 45. To change your password.. 45. Setting up preferences, the interface and the document locale.

3 46. About setting Web Intelligence preferences.. 46. Interface and document locales.. 50. Selecting the measurement unit.. 57. Increasing or decreasing the display size of a report in Web Intelligence .. 58. 3 Building and running queries.. 59. Introduction to query building.. 59. Building and running queries.. 60. Objects available in queries.. 61. About query and document user rights .. 67. Non-hierarchical queries..67. Hierarchical queries.. 68. To create a document without a data source..70. Building queries on universes.. 71. Building queries on data files.. 103. SAP BusinessObjects Web Intelligence User's Guide 2 PUBLIC Content Building queries on BEx queries.

4 107. Building queries on SAP HANA views with SAP HANA Direct Access.. 142. Building queries on SAP HANA views in SAP HANA Online mode..149. Building queries on relational connections using Free-Hand SQL statements.. 158. Building queries on Analysis View data sources.. 163. Building queries on web service data sources.. 164. To create a query on a different data source in an existing document.. 169. The Data mode in Web Intelligence ..169. To open for edit the data provider of an existing query.. 172. To set the keydates of queries.. 173. To preview query results.. 173. To sort query results.

5 174. Interrupting and canceling queries.. 174. To remove a query.. 176. To duplicate a query.. 177. Changing the data source of a query..177. Working with multiple queries and data providers.. 183. Refreshing queries in parallel.. 185. Filtering data using query filters..188. Filtering data with query prompts.. 207. Filtering data using subqueries.. 219. 4 Reporting data.. 223. Introduction to reporting.. 223. Working with reports.. 223. Web Intelligence features that are supported in reports for mobile devices.. 224. To rename a report..226. To duplicate a report.. 226. To delete a report.

6 227. To change the order of reports..227. To add a report.. 228. Viewing document properties.. 228. Hierarchical and non-hierarchical data.. 234. Finding text in a report page.. 248. Viewing modes.. 249. Folding and unfolding report data.. 252. Formatting the report layout.. 253. Reusing report elements in other documents.. 257. Printing reports.. 258. Tracking changes in data.. 259. Highlighting data using conditional formatting.. 269. Ranking report data.. 275. SAP BusinessObjects Web Intelligence User's Guide Content PUBLIC 3. Merging data from dimensions and hierarchies..283. Formatting your reports using Cascading Style Sheets.

7 298. Enhancing reports with calculations, formulas and variables.. 308. Displaying data in tables.. 319. Displaying data in free-standing cells.. 357. Formatting numbers and dates.. 359. Using sections to group data..366. Using breaks.. 373. Using sorts to organize data in reports.. 377. Working with charts in reports.. 381. Chart types.. 382. Custom Elements.. 395. Opening charts created with XI Web Intelligence .. 395. To add a chart to a report.. 396. To add a custom element to a report.. 396. Assigning data to a chart.. 397. Geo-qualifying an object for a geomap chart..399. To remove a chart.

8 405. To copy a chart.. 405. Turning hierarchical queries into charts.. 406. To set the position of a table or chart on the report page.. 407. To position a chart in relation to another chart or table.. 408. Formulas in chart elements.. 408. Formatting charts.. 409. Linking to other documents.. 444. Cells defined as a hyperlink..445. A hyperlink associated with a cell.. 446. Linking to another document in the CMS.. 447. To open a document from a hyperlink.. 452. To edit a hyperlink in a cell.. 452. To delete a hyperlink.. 452. Formatting hyperlink colors.. 453. Saving and exporting documents, reports and data in Web Intelligence .

9 453. To save a document as an Excel spreadsheet.. 455. To save a document as a PDF file.. 456. To save a document in the corporate repository.. 457. To save a document as a text file.. 458. To save document data in a CSV file..459. Saving data in a document in a CSV archive zip file.. 460. Exporting documents, reports or data.. 460. To export a document.. 461. SAP BusinessObjects Web Intelligence User's Guide 4 PUBLIC Content Exporting HTML Code, URLs, and Images to Excel Spreadsheets and PDF Files.. 462. Autosaved documents.. 463. 5 Collaborating and sharing data.. 466. Commenting on report data.

10 466. Comments restrictions and limitations..467. Security rights..468. To make a global comment with a free cell.. 469. To comment on a report section.. 470. To comment on a cell.. 471. To comment on a block.. 471. To reply to a comment.. 472. To delete a comment.. 472. To copy a comment thread.. 473. Cleaning up comments from the database.. 474. To clean up comments in the database.. 474. Displaying a specific comment.. 474. Saving a document with its comments.. 476. Using shared elements to share report parts.. 476. Shared elements restrictions..477. To create a shared element.. 478.