How to keep the column's width fixed in OTBI?

Ivony Ann Paula Salango

Hello,

I have a concern with my Activity report, the 'Activity Description' column keeps widening every time we use the 'Activity Type' prompt.

Original View/Width

After applying prompt

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26523/how-to-keep-the-columns-width-fixed-in-otbi

Hi @Ivony Ann Paula Salango,

Have you tried setting up the width of the column under 'Additional Formatting Options' under 'Column Properties'? Here's a screenshot.

It is working for me:

Before setting up the width:

Hope this help.

Thank you.

Ivony Ann Paula Salango

Hi @Bhaskar Konar , thanks for the suggestion, yes, I've tried it. The thing is, when I am already using the dashboard and added some prompts, when the results are shown, the activity description is expanding.

I can't find the reason why is it expanding after adding the prompt.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/69512#Comment_69512

Hi @Ivony Ann Paula Salango,

Thanks for the details.

I would recommend you to go one step at a time to see if it is working or is it not working when you are adding other reports etc. Sometimes the results comes from cache and makes it difficult to see the changes.

I tried the solution with prompt and dashboard and it is working for me. Please find below.

Thank you.