AnsweredAssumed Answered

Automate Report which is using OLEDB Enterprise, and Excel

Question asked by Paurav Joshi Champion on Mar 10, 2017
Latest reply on Mar 11, 2017 by Paurav Joshi

Hello All,

 

We have one daily report, which has following steps:

  1. Execute pre-defined query under PI Data Archive in PI SQL Commander.
  2. Copy output of step-1 to pivot table, which will create pivot chart accordingly.

 

What is the best way to automate whole this process?

 

Thanks,

Paurav Joshi

Outcomes