Reporting on Archived Data
We have a dashboard which reports on the main Work Table and gets the count based on a column values , we are in the process of archiving the work table periodically and store it in cloud Repository, so is there any way to report on the archived data and retrieve values from particular column (application specific exposed columns) .
Has anyone done reporting over the Archived Data? We are using Pega V8.3.
***Edited by Moderator: Pallavi to update platform capability tags***
Pegasystems Inc.
US
Hi, Will below pdn link provide any help?
https://collaborate.pega.com/question/how-report-data-archive-table-different-schema
Updated: 15 Jul 2020 20:17 EDT
Nz Police
NZ
Thanks for your answer , i had gone through the post , it mentions creating new table and store the data and report on that, which we want to avoid (creating a new table) , is there any way to run report on Archived Data and get those columns.
Nz Police
NZ
Hi Bhavya ,
The files containing the data will be in a zip format and stored in Repository, each time archival job runs , a file will be generated with archived data with the timestamp, the format is something like this format : FileName_GMTTimestamp.zip
Regards,
Nimita