We have configured DSN using driver - 'PI Integrator For Business Analytics'. It successfully connects to Server. No Issues.
Now, I am trying to configure the SQL statement against published views - 'PI Views'. The requirement is to filter records by TimeStamp range. like Where TimeStamp betweeen '*-30h' AND '*'. Any thoughts ?
With TimeStamp Filter (Error):
Any suggestions will kindly appreciated. Thanks.