Bursting to get output file as .xlsx instead of .xls — Oracle Analytics

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Categories

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

Bursting to get output file as .xlsx instead of .xls

Received Response

295

Views

2

Comments

user10953153

user10953153 Rank 1 - Community Starter

Jun 1, 2017 7:00AM in Oracle Analytics Cloud and Server

Summary

Bursting to get output file as .xlsx instead of .xls

Content

How to get output file in .xlsx format instead of .xls format through bursting

0

Answers

Sherry George Rank 7 - Analytics Coach

Jun 1, 2017 7:00AM

Use xlsx for OUTPUT_FORMAT parameter

https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/add_burst_def.htm#BIPDM394

0
Pavan kumar. Rank 5 - Community Champion

Jun 2, 2017 7:00AM

Hi,

In the Bursting Query, Add this parameter to generate output type in 'xlsx' format.

>> select

---------

---------

'xlsx' OUTPUT_FORMAT,

---------

---------

---------

from <table name>

0