Help with crosstab!!!!!!

[actcognosuser]

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.

[anilkumar]

please post screenshot

Regards
Anil k .marri

[blom0344]

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..

[MFGF]

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.