Bi publisher Expand pivot table columns by default

Pablo Moreno · Sep 8, 2025 7:58AM

Hi,

We are creating a new bi publisher reports and we have set a pivot table with several columns. We have seen that by default the tool display the columns collapsed:

Is is possible to change some property to display the columns expanded by default?

Thanks and regards.

Pablo.

Pablo Moreno · Sep 18, 2025 3:06PM

Hi!,

Any option on this? Can you confirm if the pivot table with several columns and subtotals is not posible to show expanded by default?

The client is asking me.

Thanks and regards.

Pablo.

Mallikarjuna Kuppauru-Oracle · Sep 18, 2025 9:06PM

Hi @ Pablo Moreno

Thanks for using Oracle Communities. I hope you are looking for below option -

can you check below ?

Refer - https://docs.oracle.com/cd/E23549_01/bi.1111/e13881/T527073T527081.htm

Regards,

Arjun

Pablo Moreno · Sep 19, 2025 7:43AM

hi Mallikarjuna Kuppauru-Oracle,

Thank you for your help.

I have tested the option that you mention, and this is for expand the layout grid and this not affect to the pivot table:

Thanks and regards.

Pablo.

Oracle Analytics Publisher

Categories

Bi publisher Expand pivot table columns by default

Answers