Showing blank columns in a report

[sunny8]

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

[Arsenal]

umm, did you check to see if there's data on the DB for these columns?

[sunny8]

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

[PRIT AMRIT]

Have u tested the same in FM?

[Arsenal]

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?

[Lynn]

You might also try to generate the SQL to see what it is asking for from the database.