Search code examples
oracle-databaseoracle11gobiee

Spliting a long row of records in the 'Section' into two or more rows


I have a very simple requirement. I have placed large number of attributes/columns in the 'Section' part of the table view due to which the report has became too wide and hence when exported to PDF it results in a very small font size. I just want to split the attributes in the Section into two or more rows. Is it possible?


Solution

  • You should consider getting rid of some of those attributes and move them to dashboard prompts instead. Any attribute in the "section" part of a table view (or any other view) doesn't filter your data when retrieved from the physical sources. At the moment when you run that analysis you have a query returning a huge data set and you fake it by displaying only a little piece on screen.

    You could avoid the issue of the width by using dashboard prompts which will physically filter your query instead. And a dashboard prompt can be split into multiple rows. All in all multiple small, filtered queries retrieving small sets of data don't perform worse than a single huge query and hiding data on screen.

    If you really want to split that row of selections into 2 rows you will need to add some custom CSS/js for the job, but it isn't going to change the PDF export: the PDF export process will not be able to understand your custom CSS/js and therefore still generating the exact same PDF.