analysis query updates