Hi, is there a possiblity to fixate the row/column header in a cube view in PAfE?
As soon as I drill in the hierarchies in my row or columns, the column width always jumps back to a small size which does not show the whole text of the elements.
Example:
In this view I adjusted the first column so that I can read the whole text:
If I now close or open a node within my hierarchy, e.g. close the node Profit before taxation normalized, the column is automatically adjusted so that I can no longer read the whole text.
In this view the first column is now automatically adjusted and I can no longer read the whole text:
Is there a possiblity to avoid this auto adjustment of this column?
We are using:
PA: 2.09.19
PASS: 2.0.96
PAW: 2.0.96
PAfE: 2.0.95.5 / 32bit
Office: O365 / 32bit
I already tried to figure it out on my own and also searched via goolge and within this forum.
Thanks a lot!
Fixate row/column header width in a cube view using PAfE
- gtonkin
- MVP
- Posts: 1259
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Fixate row/column header width in a cube view using PAfE
Do you get the same behaviour with the view if you open in PAW using a workbench?
And if you open the view in a Book it retains the column widths?
If so, please also log a defect as I have raised this too as it seemed to come in with a recent update (possibly new formatter) and is extremely annoying.
And if you open the view in a Book it retains the column widths?
If so, please also log a defect as I have raised this too as it seemed to come in with a recent update (possibly new formatter) and is extremely annoying.
-
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Fixate row/column header width in a cube view using PAfE
Resetting column widths in a workbench is indeed a royal pain. It's very annoying.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 5
- Joined: Thu Jun 20, 2024 8:29 am
- OLAP Product: TM1
- Version: PA Local 2.0.9.19
- Excel Version: Office 365 32bit
Re: Fixate row/column header width in a cube view using PAfE
Hi both,
I just tried in PAW and its indeed as gtonkin says.
View used in a book works fine but in a workbench I see the same behaviour.
We will log a defect at IBM.
Thanks a lot for your input!
I just tried in PAW and its indeed as gtonkin says.
View used in a book works fine but in a workbench I see the same behaviour.
We will log a defect at IBM.
Thanks a lot for your input!