Oracle Analytics Cloud and Server

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

How to remove additional space in the label when exporting to PDF?

Received Response
56
Views
4
Comments
Raghi
Raghi Rank 1 - Community Starter

I have created a graph view on OAC BI classic report and X axis label is showing Quarter (first quarter is displayed along with year). When printing that graph into PDF, quarter with year label has an additional space compared with other quarter. Please see the below screenshot.

image.png

Could you please advise, is there any option to remove this?

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi,

    Thanks for using Oracle Communities.

    Are you able to see with out any space at DB level? can you confirm.

    Regards,

    Arjun

  • Raghi
    Raghi Rank 1 - Community Starter

    Hi Mallikarjuna,

    We have separate column for Year and quarter in DB level and Subject area. In the report level, I have created a calculated column to merge first quarter and year. And there is no space after the quarter in the report. Please see the BI classic report's screenshot.

    image.png

    This additional space issue is happening when we export this report into PDF.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi,

    What is your patch level and version number of BI?

    Regards,

    Arjun

  • Rohith Banda-Oracle
    Rohith Banda-Oracle Rank 1 - Community Starter

    Hi Raghi,

    This could be more towards the columns concatenated causing the issue. What I would suggest is :

    1. Check if this is specific to PDF or Excel/PPT has the same issue ?
    2. Test the same scenario in the DV Workbook - with the subject area content and export to PDF check if issue persist.
    3. Have the calculated column defined in the DB and use it as column in the Analysis.

    Let us know.

    Thanks,

    Rohith.