Marco Legal.

If you have used any of the prediction layout model types to design a Web Intelligence (or Interactive Analysis) report, the blank cells of the report need to be formatted in a specific way so that they can be viewed on the

If the Web Intelligence report is designed according to the page layout model, no configuration is required for viewing blank cells of the report on an Android device.

4.2.1

Configuring Blank Cells in 4.0 Web Intelligence Reports

To configure blank cells in a Web Intelligence report on the BI platform 4.0, perform the following steps: 1. Logon to the Interactive Analysis Desktop client side tool in the BI platform (Enterprise) suite. 2. Open the report and go to Design mode.

The report opens in design mode.

3. In the formula bar in the document, enter the hyperlink URL for the blank cell : <a href="laction://cell? attachedto='[blocknum]'&valign='[alignvar]'&halign='[alignvar1]'"><text></a>; where

○ <attachedto>: In this parameter, specify the name of report part that you want to hook the blank cell. Note that ampersand (&) and single quote (') characters are not supported in the value for this

parameter.

○ <valign>: Specify the vertical alignment of the blank cell. There are two valid values for this: "Top", "Bottom".The blank cell appears at the top or bottom of the report part. When configuring for Android devices do not change the default set values.

○ <halign>: Specify the horizontal alignment of the blank cell. There are three valid values for this: "Left", "Center", "Right". This needs to be specified if more than one blank cell is hooked to a report part. If a single blank cell is hooked to a report part, it spans the width of the report part by default. When configuring for Android devices do not change the default set values.

○ Specify the<text>, that you want to display in the blank cell, in the body of the tag. The software does not support currently support URLs for this parameter. The text specified for this parameter is only treated as plain text and is not hyperlinked to external URLs.

You can set a background image for the blank cell. Upload the image using the Background image field under Appearance in the Properties panel.

Now press Enter.

4. Right click the blank cell and select the Format Cell option. The Format Cell window opens.

5. In the Format Cell window, go to the Display Section in the General(default) tab. For <Read contents as>

field, select Hyperlink from the drop-down menu.

6. Depending on your requirements, you can also set the values for the following parameters for the blank cell in the Format Cell window. These are optional however:

○ Alignment

You can set the text alignments in the blank cell using the dropdown fields: <Horizontal>,

<Vertical>.

You can select or deselect the Display > <Wrap text> option.

○ Font tab: You can only set the <Font Color> .

○ Border tab: Select the symbol for full borders. Border colors and partial borders are not supported in the app.

○ Appearance tab:

The Display property should be selected as Normal from the drop-down menu. Any other menu options are invalid.

In the Position field, you can set the position of the image using the drop-down menu (Left/Center/ Right ; Top/Center/Bottom).

7. Save the report.

4.2.2 Example of Blank Cell Configuration

Suppose your Web Intelligence report has four report parts: a bar chart, a line graph, a table and a blank cell. Let us assume that you make the following configuration settings for the blank cell, base on your requirements:

● In the formula bar, the hyperlink is set as <a href="laction://cell?

attachedto='block1'&valign='top'&halign='left'">Data Source GeoHive</a> (Assume that "block1" is the <Name> of the table in the report. )

● The Read cell content as field in the Format / Properties of blank cell is selected as Hyperlink. In the client view, all the report parts are independent as shown below:

c

Note

The text in the blank cell is treated as a hyperlink in the client tool and is it therefore displayed in blue.

Once the properties of all report parts including the blank cell have been saved, the report is displayed as shown below when you view the report in the SAP BI app on an Android device:

the table report part. In this case, the cell always spans the width of the report part that it is hooked to (top or bottom- based on the value of <valign>), irrespective of the specified alignment.

If there were two or three blank cells, the alignment of each cell would have been selected based on the value of <halign> specified in the text URL.

● In the single report part per screen layout model for an Android smartphone, a maximum of two blank cells can be hooked to a single report part. On the device screen, each of the two blank cell takes up 50% of the total screen size.