Hi, I hope someone can help me:
I am new to Report Studio and I can't identify where the issue with my report lies. I created subsets of bar codes in 5 queries (Set1, Set2...). This is the format I want to be able to report in:
Rev.Set1 Rev.Set2 Rev.Set3 Rev.Set4 Rev.Set5
Time Period $ $ $ $ $
I used the IF, THEN, ELSE construct to select the revenue:
IF (Bar Code = Bar Code [Set1]), THEN ([Net Rev.]), ELSE (0).
My report will not run as a whole. When I run the report with only one Set at a time, it is accurate. When I try to display all 5, it will not run.
Any suggestions?
any error messages?
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during the operation "open result". ORA-12801: error signaled in parallel query server P121 ORA-01652: unable to extend temp segment by 32 in tablespace TEMP
I don't know what it means and haven't been able to find anything in cognos support.
It should work. Could you post your logic?
If not, I'd suggest a union for your issue.
Create 5 queries each filtering for one set of value and then union them all together for a final query to report.
That error is from Oracle, not Cognos - it means something's overflowing your database temporary work area, usually a sign of bad sql (cartesian product or something of the sort).
It does sound like you could be using a union - assuming your subsets are in separate sources - are they? If not a single query should suffice.
Also, is this a crosstab or list? From the calculation you described it sounds like you may be trying to do your own crosstabbing using a list, which is technically fine as long as your number of colums is fixed, but it may be easier to use a crosstab instead.
I created a union and it worked.
Thanks.
Great :-)
Glad you got it working.