We have three servers for Cognos.
The first is where we build the cubes, develop Frameworks etc.
The second server is our Cognos Connection portal and holds our published cubes.
The third is our database server, SQL server.
Which server do I install Dynamic Query Analyser on?