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
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
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
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.
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
