RyanDonohue
Technical User
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.
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.