Dynamic Views – Styles and Formats

You can define specific styles and cell properties for elements in a dimension. These styles are stored as attributes in the In-Memory DB. You can use these styles for reports with Jedox Views.

Note: This feature is currently IN PREVIEW. To see all the buttons and UI options, make sure you also enable the UI preview features.

Setting Up Dynamic Styles and Formats

You can set up Dynamic styles and formats in the Modeler:

  1. In Modeler, select a dimension.
  2. Select the element on which you want to define a style.
  3. In the overview section of the element, click to open the Format Element dialog.

Format Element

The Format Element dialog allows you to set element attributes for style, format, row height and column width.

Style / Format

The Style / Format section allows you to define the style and format of the default, first, last, odd, and even values in a cell.

You can select a predefined style by clicking and selecting it from the drop down box.

You can also create new cell styles:

  1. In the drop down box, click New Cell Style. The Style dialog is displayed.
  2. Select the elements you want to include in your style definition.
  3. You can format your style further by clicking Format…This opens the Format Cells dialog.
  4. Click Ok. Your style is now available in the style list.
  5. You can access the Format Cells window for your already defined style.
  6. Click Ok. The style is now applied to the element.

The Format Element window allows you to see a preview of your dynamic style.

You can return to the initial settings by clicking Reset.

When defining styles on elements in a dimension, Jedox adds a set of attributes in this dimension to store style-related information. By default, these attributes are not shown in the elements grid, but you can display them.
Additionally, Jedox creates a set of rules on the attribute cube for the dimension where styles are defined. It also creates one on the #_CELL_PROPERTIES cube for each cube which uses the dimension in question. When customizing one of the existing element style classes, or creating new element style classes, Jedox will also create a new, hidden dimension inside of the database, called #_STYLES.

 

Applying styles and formats in Views

The settings you made in the Format Element dialog are visible in a Jedox View that uses the elements on which they are applied.

Note: By default, no style is applied when you paste a view. To enable styles in your view, go to the Options tab of the Paste View dialog and select the options you want to apply.

You can define which type of property (number format, style, size, or rights) to retrieve from the dimensions used on headers, columns and/or rows. For example, you can decide to retrieve number formats from the dimension(s) used on columns, and styles (such as font color, or background color) from the dimension(s) used on rows.

Properties are merged whenever possible. If there is a conflict of multiple dimensions defining an identical property, the order of precedence is as follows:

  1. Row dimension
  2. Column dimensions
  3. Header dimensions
  4. View theme

Size

You can set the size of the rows and columns containing the default, first and last values. By default, no size is set.

 

Viewing the dynamic style attributes in Modeler

To see the dynamic style attributes for each dimension element, select a dimension in Modeler and click on the Element Overview page. The style settings are shown in columns, for each element.

Using of styles and formats in custom reports

You can also retrieve cell properties in custom reports (reports which are not using Jedox Views). To enable these properties, go to Query > Cell Properties.

The cell properties dialog opens. Check the boxes for the properties you want to retrieve, and apply.

Note: Unlike in views, in custom reports, all cells are context-independent. They are not linked to a view (table) row / column / header. For this reason, you have to enable retrieval of number formats, size, and style, on the Cells level in custom reports.

Removing styles and formats from a dimension element

You can remove any style and format from a dimension element by going to the Dimension Properties tab. Expand the Advanced section and click the button. A confirmation dialog dis displayed. Click Yes. The styles and formats are now removed from the dimension.