SAP Analysis for excel - line break in the header / fixed column size

[Former Member]

Hello,

I created some reports which has a "large" heading. The user want me to insert a line break or that the report does not have the automatic column size.

Is this possible and how can I set this.

Thank in advance,

Jochen

[TammyPowlas · Accepted solution]

Assuming the BEx Query is your data source, you could try what Martin suggests in this discussion, back in the Query Designer: https://archive.sap.com/discussions/thread/3796988

[Former Member]

Hello Tammy,
I would like to set that in the analysis for excel - map. I didn´t found how to make that there. Every time when I open the analysis map, the column are resizing with the longest data value.
Regards Jochen

[TammyPowlas]

Can you share a screen shot of what you are seeing? Use the image icon to upload

[Former Member]

Hello Tammy,

when there is an long text like in this example, the width is to large. How can I make a fix width or a maximum width in Analysis for Excel?

Thanks!

[TammyPowlas]

Hello Jochen - I try to go for the easy answer first - see if this thread helps https://archive.sap.com/discussions/thread/3684897 - if not, reply back

[Former Member]

Hello,

that works. But there is a similar question. There are some data "String" in the row, which are very long. How can setup a fix or maximum column size?

Regards Jochen

[TammyPowlas]

Hi Jochen - good to hear.

On your follow up question, are you asking how to do that in the BEx Query Designer? If so I recommend posting a new discussion/question in the Business Explorer space at https://www.sap.com/community/tag.html?id=834511320631052684142696158061592 (I am not an expert in that area)

[Former Member]

Thank you. I will try that out.