The query we are using is too complex for the DW recordset to follow. You would have to update it in code view.
We will probably define a query in the mySQL database in the next version of Powerstore so that the recordset query can be simplified and made editable in DW server behaviors.