Srinivas

Query is not working in PI Data Services

Discussion created by Srinivas on Aug 29, 2013
Latest reply on Aug 29, 2013 by cpan

Hi ,

 

I have a query which in the PI SQL commander which pulls the events information from AF database. The same query If I used in the PI data services to  create a new dataset. the following error message being displayed when clicked on the Verify SQL.. I am  using the CROSS APPLY on the transpose function of event frame template.

 

syntax error near CROSS..

 

PI Webparts version is 2010 R2 and PI SQL commander is 2012 version...

 

Request your help to resolve this issue.

Outcomes