Skip to main content
M
Morgane
April 8, 2025

Format - Header Text alignment

  • April 8, 2025
  • 3 replies
  • 0 views

Hello,

I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports).

It seems there is no option to do that in the format parameters (only in Excel).

I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages.



Do you know a solution to get a more consistent presentation ?

Thank you in advance,

Morgane

3 replies

T
T_Kress
April 8, 2025

In the header format section of your cube view, have you tried any of these?

Red is for cube views

Green is for Excel

Purple is for PDF Reports

 

M
MorganeAuthor
April 9, 2025

Hello,

Thank you for your answer.

For Excel, it's working thank you.

For the Cube Views => the "mergeandcenter" option does not align the text in the column headers.

For the reports => I am afraid it is not fully satisfying. It's better than before (horizontal alignment) but descriptions appear oddly :

 



 

Thank you for trying,

Morgane

T
T_Kress
April 9, 2025

It looks to me like, in the columns, you are using a .TREE expansion.  If you use .TREE instead of .DESCENDANTS you will get odd indentation that only works great if the dim is in the rows, not the columns.

Try changing your column expansion from .TREE to .DESCENDANTS and see how that looks instead.

M
MorganeAuthor
April 10, 2025

Hello,

I use a .BASE expansion in my column :



 

I have tried with the .DESCENDANTS expansion but there is no change in report presentation.

Thanks,

Morgane

A
Anonymous
February 24, 2026

Have there been any answer how to align Header text to the top vertically for report formatting?

Terms & ConditionsAccessibility statement