Oracle Transactional Business Intelligence Idea Lab

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

Reports - Export Aggregated Data into Excel, Clean expression not maintained

1
Views
0
Comments
Abbey Seeber
Abbey Seeber Rank 1 - Community Starter

Description

When you export aggregated data with an applied clean expression into excel the data no longer remains aggregated and each piece of data is entered into it's own cell.

Use Case and Business Need

When you export aggregated data into excel the data no longer remains aggregated and each piece of data is entered into it's own cell.  This makes it almost impossible to sort your data or manipulate it once it is in Excel.  We have found a lot of problems when it comes to our AAP reporting and using the field titled Aggregated Requisition Owners.  The clean expression that you can add will help the report generate correctly to view but once you export, it is lost.

Original Idea Number: 38ef6915a0

1
1 votes

Submitted · Last Updated