Working With Web Intelligence Documents

In Web Intelligence documents, you can view report information in sections, drill on hierarchical data in charts and tables, filter data using input controls, refresh reports and perform a whole lot of other actions on report parts.

How do I reorder table columns?

To reorder the columns of a vertical table, tap and drag the header of the column to the left or right on the screen.
Note When you tap and drag a column header for reordering, it turns blue.

To reorder the rows of a horizontal table, tap and drag the row headers up or down on the screen.

How do I freeze or hide table rows or columns?

  • To freeze a column in a vertical table, double tap the column header, and choose Freeze.
  • To freeze a row in a horizontal table, double tap the row header, and choose Freeze.
  • To hide a column in a vertical table, double tap the column header and choose Hide.
  • To hide a row in a horizontal table, double tap the row header, and choose Hide.
Note To unhide or unfreeze a row or column, double tap the header and choose Unhide or Unfreeze.

How do I filter information in a report?

Pre-requisite: The report designer should have configured input control based filters while designing the Web Intelligence report on the server.

  1. Tap the Filter IC Icon (Filter) icon that appears in the bottom bar of the report.

    The Filters screen appears displaying the dimensions (with their values) according to which you can filter information in the report.

  2. Tap the arrow (>) symbol next to the dimension names in the pop up to see the value list, and make the required selection of values.
    Note Some dimensions may have hierarchical values and you may need to traverse down a hierarchy for making the selections. Some dimensions may be based on a range of values, in which case you need to move the slider position to the left or right based on your requirements.
  3. Choose Apply in the Filters pop up.

    The report is refreshed to display the information based on your selected dimension values.

How do I sort or wrap column data in a table?

  • To sort the data in a column in ascending order, double tap the column header (or row header in a horizontal table) and choose Sort Ascending.
  • To sort the data in a column in descending order, double tap the column header and choose Sort Descending.
  • To wrap the contents of cells within a column, double tap the column header (or row header in a horizontal table) and choose Wrap.
Note To undo an action, double tap the column header again and choose the required option.

How do I drill information in a report?

Note Drill options appears in a report only if the report is based on hierarchical data and the report designer has enabled drilling in the report.
Drilling in Charts
  1. Tap on a data-point (in a line-chart) or tip of the bar (in a bar-chart) as shown in the below figure: Drill_WebIChartsA pop up appears displaying the measure value corresponding to that node or bar. In the pop up, choose the up-arrow symbol to drill up, and the down-arrow symbol to drill down.
    • Depending on how the hierarchy is defined in the report, the information is drilled and the chart displays the new information. For example, if the chart displays <Revenue> versus <State>, drilling up may display the Revenue versus <Country> and drilling down may display the Revenue versus <Store Name> if the defined hierarchy on the server is Store Name->State->Country.

Drilling in Tables

Tap on any cell within the table column that you want to drill, and select Drill Up: <Higher Dimension> (to drill up) or Drill Down: <Lower Dimension> (to drill down).

For example, if you tap on a cell within the <City> (dimension) column, you may get options to Drill Up: State and Drill Down: Store Name if the defined hierarchy on the server is Store Name-> City-> State

The information in the table is refreshed to display the drilled information.
Note If you tap on a cell within the measure column (for example Sales Revenue), the pop up may display multiple dimensions on which to drill up or drill down. For example, if Sales Revenue is dependent on Year and State dimensions, the pop up may display Drill Down: Quarter, City.

How do I analyze information in geo-analysis?

Geo analysis (or geomaps) display information in a geo-localized format. Geo analysis displays BI data for different geographic locations on the world map. These locations are known as points of interest (POIs). Each POI has a unique value of location (latitude, longitude) and name (such as city-name, state-name, company-name or store-name).You can analyze information in geo-analysis through:
  • Web Intelligence Geo-map (only datapoint type Bubble is supported)
    Note Geo-maps are supported on SAP BusinessObjects Mobile Application from BI 4.2 SP3 onwards.
    For details on Web Intelligence Geo-maps refer Web Intelligence User Guide
  • Geo- map created using tables(legacy).

Viewing Data for Different Measures in geomap

Once you open a geo analysis report, it displays the information corresponding to a default measure defined by the report designer. On tapping a point of interest (POI), the measure value corresponding to that location (POI) appears in a pop up.
Note If the report designer has configured an Open Document URL for the points of interest in geo-analysis, then instead displaying measure values, the pop up displays a report part (chart or table) with information specific to the POI.

To view information for a different measure in geo analysis, tap the measure header that appears on the top of the report and select the required measure from the list that appears on a new screen.

The information in geo-analysis is refreshed to display the POI values for the selected measure.

Viewing Data for Different Dimensions in geomap

Once you open a geo analysis report, it displays the information corresponding to the default dimensions defined by the report designer.

To view information according to different dimensions in geo analysis, tap the dimension header that appears on the top of the report (below the measure header) and select the required dimension from the list that appears on a new screen.

The information in geo-analysis is refreshed to display the values according to the selected dimension.
Note The application retrieves the World map in geo analysis from Apple maps available over the internet. So if you have opened the geo analysis document in your Corporate network, you may need to temporarily switch the Wifi connection to the Internet to retrieve the World map in geo-analysis. Once the map (with geographic locations) loads in the report, you can switch back to the Corporate network to continue working with the application.

Similarly, if you have downloaded a geo analysis document and you view it offline, only the points of interest (POIs) appear on the screen and the map is unavailable in the background.

How do I View Report information in Sections on iPhone?

Sections allow you to split report information into smaller, more comprehensible parts. When the report designer has defined sections in a Web Intelligence report, a Sections_iPhone (Sections) icon appears at the bottom of the report on the screen.

On tapping it, a "Sections" panel appears on the screen that lists the dimension values according to which you can view information in the report. If the dimensions are hierarchical, the values may appear in a hierarchical manner.

For example, in the "Sections" panel, you can select a value for year (for example 2004), and then a specific quarter (Q1/Q2/Q3/Q4) within the year to view the respective (sectioned) information in the report.

How do I use prompt variants?

To simplify the selection of values each time you open a report, all the parameters that you chose previously are saved as a variant. Every time you refresh the report you can select the variant directly instead of selecting every parameter that you want to view. To use prompt variants, proceed as follows.
  1. Open the Web Intelligence report.
  2. Tap the Refresh icon. The Prompts dialog box appears.
  3. Choose Prompts Variants and select the variant you want from the list of variants that appears. Prompts Summary in the dialog box is updated automatically.
  4. Tap Apply.