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:
- In Modeler, select a dimension.
- Select the element on which you want to define a style.
- In the overview section of the element, click to open the Format Element dialog.
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:
- In the drop down box, click New Cell Style. The Style dialog is displayed.
- Select the elements you want to include in your style definition.
- You can format your style further by clicking Format…This opens the Format Cells dialog.
- Click Ok. Your style is now available in the style list.
- You can access the Format Cells window for your already defined style.
- 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.
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:
- Row dimension
- Column dimensions
- Header dimensions
- View theme
You can set the size of the rows and columns containing the default, first and last values. By default, no size is set.
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.