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

Multiple rows in a single row after join

Started by Cognos_World, 10 May 2012 03:02:05 PM

Previous topic - Next topic

Cognos_World

I want to get a single row from multiple rows after 2 tables are joined. I have a condition based on date.
If date1 = date 2 then date1 else null.
This is giving multiple rows and these are required in the report.

Is there any way to get the data in a single row.

E.g

100   
           200

Result:

100     200

I have tried various aggregations, that didn't helped.

Any workarounds?



pricter


bi4u2

If you create the query subject in Framework Manager based on your requirement, you can change the Options on SQL from 'Minimized SQL' to 'As a View'. This would put everything on one row.

Lynn

What aggregations did you try? I'd think a maximum on the date item and total for the measures would have done the trick.

Or try a query reference so that your base query with the multiple rows is feeding into another query, then set the aggregation on the query items in the new query. This would introduce local processing so beware of performance implications.