Formatting hyperblocks

In Design mode, click the border of the hyperblock to select it.
Right-click the hyperblock and select Format Hyperblock. Optionally, click the hyperblock and select Format > Object Properties. The Format Hyperblock dialog box is displayed.

On the General tab, specify this information:

Name

By default, hyperblocks are named HyperblockN, where N is a sequential number. You can change the name to simplify referencing hyperblocks in formulas.

List

You can change the list that is assigned to the hyperblock. For example, change from a local list to a global list.

Copy to local

Converts a global list to a local list. This option is not available for hyperblocks on slices.

List Designer

Opens the list designer. This option is not available for hyperblocks on slices.

Paging

Note: You cannot use paging with expandable slices.

Use the Page size and Current page fields to display a list over multiple pages. Specify variables in the fields and use actions to control their values. Page size specifies how many elements are displayed on each page.

Page size and current page number are two paging-related hyperblock properties that you can reference in reports. This is the full list of paging-related properties:


Property	Syntax
Page size	`=ReportObjects.[HB_name].pagesize`
Page count	`=ReportObjects.[HB_name].pagecount`
Current page number	`=ReportObjects.[HB_name].Currentpagenumber`
Current page size	`=ReportObjects.[HB_name].Currentpagesize`
Row count	`=ReportObjects.[HB_name].Rowcount`

Alternatively, use the Paging web extension to implement paging.

Global output cell properties

To make hierarchical lists expandable and collapsible in Report view, check the Use global settings for hierarchy output cells check box.

Note: When defining global output cell properties, you can not define different settings for different hierarchies in a hyperblock that expands a slice.

Begin expansion at level

Select the check box and specify the initial expand level to expand elements with expand and collapse icons.

Clear the check box to expand all elements without expand and collapse icons.

You can use a formula to set the expansion level dynamically.

Specify 1 to display only the top level of the hierarchy.

Specify 0 to expand all elements, with icons to expand and collapse all or parts of the list.

Specify -1 to expand all elements without expand and collapse icons.

You can use a formula to reference an XML variable to configure dynamically any number of hierarchies on the axis. For example, create a report variable ExpandXML and paste this <Table> as value in Properties - Report Variable pane:

<Table> 

    <Row name="[Product]"> 

       <Property name="ExpandLevel" value="1" /> 

       <Property name="Indent" value="TRUE" /> 

    </Row> 

    <Row name="[Region]"> 

       <Property name="ExpandLevel" value="2" /> 

       <Property name="Indent" value="TRUE" /> 

    </Row> 

    <Row name="[Period]"> 

       <Property name="ExpandLevel" value="3" /> 

       <Property name="Indent" value="FALSE" /> 

    </Row> 

    <Row name="Default"> 

       <Property name="ExpandLevel" value="1" /> 

       <Property name="Indent" value="TRUE" /> 

    </Row> 

 </Table>

The variable is applied when the referenced hierarchy name is part of the list or slice definition. The row name Default is applied to hierarchies which are not part of the XML definition. In case the XML definition has no Default row, the expansion level is set to 1.

Indent labels

If selected, then each level of a hierarchical list is indented in relation to the level above it. Clear this box to display levels directly beneath each other. When using a formula, specify TRUE or FALSE. You can use a formula to reference an XML variable to configure dynamically any number of hierarchies on the axis. Create a report variable ExpandXML and use the above example as value in Properties - Report Variable pane.

On the Output Cells tab, specify this information:
New

Creates a key output cell.

Value

The Value section lists the key output cells and value cell of the hyperblock.

Display Value (~)

You can specify whether the hyperblock displays, for example, the unique names of elements or their captions. Your selection can be affected if a number format is applied to the key output cell. If the number format of the key output cell is the tilde character (~), then the selection in the Display Value column has effect. But if @ is selected as the number format, then the hyperblock displays the unique names of elements, whatever is selected in the Display Value column.

Position

You can specify the position of the key output cell within a hyperblock.

Properties of

Shows the properties of the selected cell.

Allow expand collapse

Select the check box to enable expand and collapse buttons.
Note: For a slice list, to identify the hierarchy, select Unique Name in the output cell.

Begin expansion at level

Note: This option is only active for output cells with the value Unique Name or <hierarchy> unique name.

Select the check box and specify the initial expand level to expand elements with expand and collapse icons.

Clear the check box to expand all elements without expand and collapse icons.

You can use a formula to set the expansion level dynamically.

Specify 1 to display only the top level of the hierarchy.

Specify 0 to expand all elements, with icons to expand and collapse all or parts of the list.

Specify -1 to expand all elements without expand and collapse icons.

You can use a formula to reference an XML variable to configure dynamically any number of hierarchies on the axis in the selected cell. In slices, the XML variable must be used only on the global output cell properties.

Indent labels
Note: This option is only active for output cells with the value Unique Name or <hierarchy> unique name.
If selected, then each level of a hierarchical list is indented in relation to the level above it. Clear this box to display levels directly beneath each other. When using a formula, specify TRUE or FALSE. You can use a formula to change the value for all hierarchies dynamically in the selected cell. You can use a formula to reference an XML variable to configure dynamically any number of hierarchies on the axis in the selected cell. In slices, the XML variable must be used only on the global output cell properties.
Note: Enable expand collapse and initially expand to and Indent labels options are disabled when you select these items:

Global output cell properties settings in the General tab.

An output cell without the Unique Name value.

Value cells item.
Fill style

By default Standard is selected. The Fill style is not available when Value cells is selected.

Use caption as value if display string is empty

Select the check box to enable fallback to a caption if the displayed value is empty, for example, if the selected attribute does not have a value.

Merge elements of expandable slice

Select the check box to hide outer dimension elements under one label in an expandable slice.
Note: To identify the hierarchy, select Unique Name in the output cell.

Column width

For each output and value cell you can define, how the column width is calculated. Use current width uses the width that the column has in the report spreadsheet definition. Calculate width automatically uses the content of the hyperblock to calculate the width. You can set the same width for all columns, the minimum width, and the percentage on which the width depends.
On the Appearance tab, specify whether the hyperblock is displayed with a border and, if so, the color and thickness of the border.
Click OK.