Insert 0 value for missing values in a cross tab.

[Raghuvir]

Hi All,

Relational Model

Cognos 8.4

We have multiple crosstabs placed in the report design which use different queries. Please see the attached format of the cross tab.

in the Total Revenue crosstab, values for 2015 are missing in the database because of which its showing blank space. in the revenue field i tried writing the condition as if([AMT] is missing) then (0) else ([AMT]), it dint help me to achieve what i was looking for.

Request you to guide me on how to achieve this.

Regards

[SGD]

in the Total Revenue crosstab, values for 2015 are missing in the database because of which its showing blank space. in the revenue field i tried writing the condition as if([AMT] is missing) then (0) else ([AMT]), it dint help me to achieve what i was looking for.

You can use 'Define Contents' property of Crosstab. Using this property you can hide measure values for individual cells or to define customized content.

[Raghuvir]

You can use 'Define Contents' property of Crosstab. Using this property you can hide measure values for individual cells or to define customized content.

hi SGD,

That's not working for me. is there any other way we can do that ?

Regards

[MFGF]

Hi All,

Relational Model

Cognos 8.4

We have multiple crosstabs placed in the report design which use different queries. Please see the attached format of the cross tab.

in the Total Revenue crosstab, values for 2015 are missing in the database because of which its showing blank space. in the revenue field i tried writing the condition as if([AMT] is missing) then (0) else ([AMT]), it dint help me to achieve what i was looking for.

Request you to guide me on how to achieve this.

Regards

I'm only seeing one crosstab there? Or is it two crosstabs stacked vertically on top of each other, with the column titles hidden for the second one?

What does "That's not working for me" mean?

MF.

[Raghuvir]

Hi MFGF,

yes there are multiple crosstabs stacked on top of each other, we have hidden the column titles.

i tried the solution given by SGD but that dint worked...it was still showing the blank spaces. i used the "No Data Contents" property, but was not able to define content in that.

Regards

[MFGF]

Hi MFGF,

yes there are multiple crosstabs stacked on top of each other, we have hidden the column titles.

i tried the solution given by SGD but that dint worked...it was still showing the blank spaces. i used the "No Data Contents" property, but was not able to define content in that.

Regards

The issue I think you have is that the columns you are wanting to display 0 in don't physically exist in the lower crosstab. Can you modify the query for the lower crosstab so that these column values exist?

MF.

[Raghuvir]

The issue I think you have is that the columns you are wanting to display 0 in don't physically exist in the lower crosstab. Can you modify the query for the lower crosstab so that these column values exist?

MF.

Hi MFGF,

The crosstab column contains data item "Fiscal Year" (for all crosstabs). the data for the "Total Revenue " crosstab is coming from a SQL table where revenue for 2015 is NULL. the crosstabs below revenue are calculations dependent on the revenue thats why those are also showing blank.

i will try to modify the queries and update you if i get any solution.

Regards