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 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.
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.
- Tap the
(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.
- 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.
- 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.
How do I drill information in a report?
- Tap on a data-point (in a line-chart) or tip of the bar (in a bar-chart) as shown in the
below figure:
A 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
How do I analyze information in geo-analysis?
- 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
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.
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) 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?
- Open the Web Intelligence report.
- Tap the Refresh icon. The Prompts dialog box appears.
- 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.
- Tap Apply.