Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Data Warehouse report to include count of results returned

Avatar

Level 3

1/13/11

It would be WONDERFUL  if in the email that I receive when an ftp'd data warehouse report is ready to be picked up -   that the number of rows that have been returned in the report request would be stated.

 

I am running reports and the data set coming back is too big to display completely in excel.

 

So  in the Details section of the email    in addition to these items: 

there was also  a line for    "Rows returned"        nn,nnn,nnn

File Delivery

File Name:

Jo_Lynn_Clark_daptiv_458.csv

File Format:

Comma-separated Values (CSV) - zipped

Delivery Method:

FTP

FTP Host:

ftp.omniture.com

FTP Directory:

.

2 Comments

Avatar

Level 2

1/14/11

It would also be helpful of DataWarehouse reports had some basic headings in the file.  All of the lables are in the email and if you have several open it is easy to get confused about which is which.

 

Being able to formate the DataWarehouse report to easily drop into a pivot table would also be a gift.

Avatar

Level 2

3/14/11

It would also be nice if we could have the rows returned come as an additional file to the FTP location.  This would allow me to automate the loading process to ensure rows sent = rows loaded into the database.

 

This could also be implemented as a "Totals" row to the existing file which could provide not just counts, but total for that column.