Hi PI genius,
We're working on a report, which requires us to provide 10 minute interval data for a few AF attributes on monthly basis. In each monthly report, we have to cover all the months since the beginning of the term year. Beyond the 10 minute data, we have to also provide the calculated results in the same Excel file where the raw data lives, and the customer will verify our calculation results based on the raw data provided.
Since we're asked to provide the report automatically every month, we're thinking to use SSRS just as our other projects. I'd imagine at some point during the term year, the data volume will be a huge issue for OLEDB enterprise and SSRS. Has anyone ever run into similar scenarios? Is there any suggestion what is the most efficient approach to provide both raw and calculated data?