I have 6 columns in a crosstab.Each of them have a different calculation based on different filter condition.
I need to display all these columns in a single crosstab or atleast make it appear that they are from the same crosstab.
Since ,the filters are different should I put those dataitems in different queries and
make it appear as columns of the same crosstab?Is there a better way to do it?
Union might not work.
please post screenshot
Regards
Anil k .marri
Quote from: actcognosuser on 28 Dec 2009 03:12:00 PM
I have 6 columns in a crosstab.Each of them have a different calculation based on different filter condition.
I need to display all these columns in a single crosstab or atleast make it appear that they are from the same crosstab.
Since ,the filters are different should I put those dataitems in different queries and
make it appear as columns of the same crosstab?Is there a better way to do it?
Union might not work.
Pardon? A union WILL work and is probably the only way to build this. It will also be a very clean solution where Cognos can render the resulting crosstab very quickly..
The union will allow storage of all facts in 1 dataitem , which makes it a simple solution..
Hi,
Is the package a dimensional or relational one?
If you are using a relational package, you will need to UNION multiple queries as Blom says.
If you are using a dimensional package (DMR or OLAP), you can do this all in one query - drag in a series of query calculations and use the filter() function in each.
MF.