If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report server not responding when moving filter to tuple. Please help.

Started by EVilGnome, 19 Mar 2012 08:21:46 AM

Previous topic - Next topic

EVilGnome

I have a list report that needs to use different members of my ledger (Budget and Actual), date (current month, prior month, prior year), and measures (current month vs YTD).

I can successfully create the report using tuples for ledger and measure when the date is applied as a filter.

In order to create the multiple dates that I need to view, I have 2 options:

1) Add another field to my tuple to create a 3 way intersection with these fields.
ISSUE - When I add date to the tuple, I get the report server not responding error immediately when I run or compile the report.

2) Union multiple queries that have a different filter for each date. I have tried this and the queries individually work fine.
ISSUE - When I union them, I get the error message "Cognos subquery <query name> used in a set operation cannot use members or member functions.

I have to be able to calculate variances so I am unable to line up multiple lists.

I am unable to figure out how to get past these errors. If you could please provide any advice. I will be happy to send the report design with any of my attempts.