Cross tab display.

[raja1718]

Folks,

I have created a cross tab for Applications and the counts corresponding to the year.lIEK

Like Below Structure

                                2009             2010              2011

Applications Name1 

Applications Name2
..
..
..
Application Name10

My problem is I have around 10 application totally.

If there is no record for any of the years that any of the applications its not showing up in the cross tab.

for example if no records for the Application2 for the years 2009,2010,2011 its not showing up in the cross tab.

I want to display all the 10 application names in the cross tab and if there is no count for the particular
application need to show that application as well with zero's.

Please let me know if any way to fix this in report studio.

Thanks in Advance guys.

Raj

[kattaviz]

Hi,

Try to make the missing measure a zero value. (if [Measure] IS NULL then 0 else [Measure])

HTH

[raja1718]

Sathish,

Thanks for your reply.

I tried but still its not showing up and also not giving the right values.

Raj

[cognos123]

Hi,

try this one .

Select each Crosstab node Member  and change  source type  member caption into data item value.( make it for all node members)

then select  Crosstab intersection , selct data format  number/currency /%   then make missing value '0' (for all)


:)

[Arsenal]

If it still doesn't work, in FM change the table's relationship, where the application1, 2 etc. is coming from, to be a 0.n against the fact

Can also do this via joins in the report locally. Check this link:

https://www-304.ibm.com/support/docview.wss?uid=swg21341708

[RobsWalker68]

Hi,

Also remember to check that suppression is not turned on.

Rgds

Rob