Number of columns limitation in Bi publisher — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Number of columns limitation in Bi publisher

Received Response
738
Views
5
Comments

Summary

Number of columns limitation in Bi publisher

Content

Hi,

In bi publisher, i am facing with exceeding more no of columns so while creating reports from specific datamodel i want to pull 25 coloumn at time in bi publishr report . but the table is showing there is no more enough space. so, is there any way to increase space llimit or to include all columns. please let me know about this

Answers

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    25 columns is not big number, you may have to change page size and orientation.I suggest adding 10 or 15 columns and then add 1 after the another while viewing the output, just to make sure where exactly its failing..

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Modify your page layout to a larger paper size ...

  • Christian Thibaudeau-90201
    Christian Thibaudeau-90201 Rank 5 - Community Champion

    Hi there, i've done something similar...maybe it could help.

    1 - I've created an rtf Template with 35 columns which were very small. columns are 1 char large and the titles are top to down

    ex :

    image

    2 - Under this table, I reference xml field

    image

    3 - In the data model definition, I've specified that the default output is Excel

    So, the 35 columns are opened in Excel...

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    as mentioned by other users, change your orientation and page size .. interactive reports allow upto A3 size which can hold lot of columns, if still you need more columns, trying reducing the font size to accommodate more.

    --YG

  • Carlos Bribiesca
    Carlos Bribiesca Rank 1 - Community Starter

    But, what happen when you need a larger page?, I don't understand why the BIP report are limited to page sizes. It doesn't have any impact in Oracle, just in their customers.