getting lot of unknown counts in the table...?

[vishalgoud]

hi all,

i have a summary table which will show counts for each revenue group and from 5 different qvds (A,B,C,D and E) am pulling values into that table.

by concatinating all 5 qvds into a single FACT Qvd and each qvd is having a flag using which am bringing data from that particular qvd.

so each qvd data into each column where as the dimension is revenue group.

for one particular column am getting more number of unknown values due yo which that column total showing a lot.

Any pointers on this please, how to identify that unknown values from where they are coming....

thanks Much !

[kaushiknsolanki]

Hi,

If the flag is maintain properly it should help you to know from which QVD you are getting the data.

If possible post the script and the output it shows for better understanding of your problem.

Regards,

Kaushik Solanki

[shiveshsingh]

You need to debug which records are coming extra and why.. can you post your script or app to check further?