Query works fine in SQL Server Query Analyzer / Management Studio but returns nothing in BIPLUS. A possible reason for this is “Remote Query Timeout” setting in sql server which is not applied in Sql Server Management Studio or Query Analyzer.

You can change this setting from Management Studio –> Properties on Server Node –>Connections.