PCMCS - Extract huge data set and email

Hi All,

We have a requirement to send out emails with huge volumes(1.3 million records) of data to business users for recon.

Wanting your suggestions, as we used to send them HFR reports from PCMCS, but this huge report is definately not possible.

other options we explored

1) DM export (takes 20 mins to extract + can't send email directly)

2) Queries - level 0 data are also failing in our environment. (raised an SR already)

Any other suggestions / thoughts for this automated reports in email for such huge data volumes?

Thank you in advance!

Cheers,