Solved

Cognos expression result  is not being displayed in report

Posted on 2011-09-09
4
531 Views
Last Modified: 2012-05-12
Hi,

In the crosstab report I am using one of the expression as

if([Type]= 'M') then('Mag zines.') else('book')

so it shows the count of each for a store.. But if that store does not have magzines  for a time period(like Quarter)  then it should display '0' but it is not pulling that column at all.

It is just  pulling book and displaying its numbers.
0
Comment
Question by:new_perl_user
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:SNeupane
ID: 36511638
It could be because of null suppression that is automatic in crosstab.
Change expression of your measure to coalesce () or nullif or (if null then 0 else measure) etc... expression.
Use the one that works according to your database.
0
 

Author Comment

by:new_perl_user
ID: 36512672
the [Type] data item I am using above is text  so when I am using coalesce () it errors out.

If possible can you please let me know how to use nullif and others with an example of condition/expression
0
 
LVL 8

Accepted Solution

by:
SNeupane earned 500 total points
ID: 36512868
then use a if else statement to check for null and if null put '0' value.
0
 

Author Comment

by:new_perl_user
ID: 36513157
how doe we check for a null from the above expression

if([Type]= 'M') then('Mag zines.') else('book')
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question