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 Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
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!

Welcome to the Oracle Analytics Community

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

Comments

'REP_SPC_DEM_INV_VIS_CUBE_' ||TO_CHAR(SYSDATE, 'DDMMYYHH24MISS') ||hash ||'.csv' PARAMETER5,

in BIP compress output prior delivery Comment by Niketa Ashwini Apr 28, 2020 9:43AM
Reports returning millions of record and size is also in MB's. so to Split CSV file we use bursting with del channel "FTP" and ORA_HASH function.

in BIP compress output prior delivery Comment by Niketa Ashwini Apr 28, 2020 9:38AM
This works fine when "Compress output prior to delivery" option is unchecked at the time report job submission. But when we select "Compress output prior to delivery", system splits CSV and created multiple zip files but puts same CSV is all zip, which is incorrect.

in BIP compress output prior delivery Comment by Niketa Ashwini Apr 28, 2020 9:37AM
'Itronpdhdev' PARAMETER2,

in BIP compress output prior delivery Comment by Niketa Ashwini Apr 28, 2020 9:27AM