Oracle Analytics Publisher

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

Excel Template Scalable Mode to true from Runtime Properties?

Closed
1881
Views
6
Comments
Rank 1 - Community Starter
edited Nov 14, 2024 4:15PM in Oracle Analytics Publisher

Waiting Time: 0.6 seconds

Data Fetch Time: 1.9 minutes

Total Execution Time: 2.3 minutes

Job Priority: Normal


Output fejlede.

[INSTANCE_ID=bip.bi_server1] [OUTPUT_ID=1608279] oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties.

[INSTANCE_ID=bip.bi_server1]

How do we turn that Excel Template Scalable Mode to true ?

Which run time properties are the error refering to?

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • At report level or server-wide in the Administration page > Runtime configuration > Properties.

  • Rank 1 - Community Starter

    I cant able to identify the path

  • Rank 1 - Community Starter

    Open report in edit mode → properties → Formatting → Excel Template. Set report value to true and save.

  • Rank 8 - Analytics Strategist

    Hi @User_4FWIE

    Below is the navigation screenshots for your reference - system level Using Administration page.

    OR

    Report level -

    Regards,

    Arjun

  • Rank 1 - Community Starter

    It does not copy the header column. How can we get the header column

  • @User_86E2M ,

    Not sure what you mean with your message (the thread is about where to set a parameter based on an error OP got).

    Because this is a old thread, you could ask a new question, describing your situation, your question, the current behavior, the expected behavior, and what you did so far to try to change it. And also the product name and version you are using (as features can be different based on the product you use).

This discussion has been closed.