Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sunny8 on 01 Aug 2011 02:02:09 PM

Title: Showing blank columns in a report
Post by: sunny8 on 01 Aug 2011 02:02:09 PM
Hi
I am getting some 6 columns as blank in a report
like ca MTKG QOH,  Moulton QOH,  K/P Corp QOH, ArvatoQOH, Oneil QOH, Other vendor QOH are the 6 columns
can any one suggest me regaarding this
I mean any properties can be reset to solve the issue..

Thanks in advance
Title: Re: Showing blank columns in a report
Post by: Arsenal on 01 Aug 2011 03:01:25 PM
umm, did you check to see if there's data on the DB for these columns?
Title: Re: Showing blank columns in a report
Post by: sunny8 on 02 Aug 2011 03:26:00 AM
Ya sure der is data for those columns in DB and as well as we hv checked in the Query studio also. We found data for those columns in Query studio also

Thanks...
Title: Re: Showing blank columns in a report
Post by: PRIT AMRIT on 02 Aug 2011 04:27:20 AM
Have u tested the same in FM?
Title: Re: Showing blank columns in a report
Post by: Arsenal on 02 Aug 2011 09:58:26 AM
check your join key and cardinality in FM..for example, if the columns are coming from a fact and a dim table, is the join condition defined in FM causing the columns to return null?
Title: Re: Showing blank columns in a report
Post by: Lynn on 02 Aug 2011 10:36:32 AM
You might also try to generate the SQL to see what it is asking for from the database.
Text only | Text with Images