Dynamic formatting of table headers
Dear Pyramid-Team,
when using OLAP-Cubes of MSAS, Pyramid is able to use the Measure formats defined in the cube.
As far as I know, this definition can also be dynamic (e.g. based on attributes) and is not restricted to the number format, but can also include information of whether the measure should be displayed bold, italic, underlined etc.
Thus, it could be, that in the cube is defined, that for a certain customer (element of the customers dimension) the measure, AND the customer itself as well, should be displayed in bold characters/figures.
Is there a way to let Pyramid use this information, so that in a table grid this customer (in the row or columns header) is displayed in bold characters as well as the measure shown in the corresponding table cell is displayed in bold figures?
Many thanks in advance.
Kind regards
Markus Loy
3 replies
-
We only support data formats, foreground and background colors from the cube. You can turn that on from the Query tab with "Model Colors" and "Model Formats". Font settings are ignored.
These can be defined at the member level, measure level or cell level from inside the cube. They can also be defined from Pyramid for measure and member level.
-
Hi Avi Perez,
We only support data formats, foreground and background colors from the cube. You can turn that on from the Query tab with "Model Colors" and "Model Formats". Font settings are ignored.
OK, understood.
These can be defined at the member level, measure level or cell level from inside the cube.
OK, understood. But if Pyramid ignores these settings - as you wrote above - it's useless for me.
They can also be defined from Pyramid for measure and member level.
Really for member level? Globally, i.e. for all users?
Or did you mean row/column level in a specific grid? I'm asking because the latter option I found (screenshot), but I cannot find, where and how to set formatting options for members.
Kind regards
Markus -
Member level formatting is applied on a custom member/measure (both from the cube and Pyramid). In Pyramid, you would set these up in the properties of the custom member (aka "Formula") designer in the orange Formulate app.
