Data values Problem

[krishna20]

Hi Friends,

There is a problem in data. The amount in the database(Oracle) and to Qvw file is not matching for individual companies.But, the total  amount is showing as correct. I took Company name as Dimension and in expression sum(Amount).I reloaded the whole three tier applications.But,the problem is not rectified.Anyone pls help me out,what may be the problem is.?

Regards

Krishna

[ashfaq_haseeb]

Hi,

Can you attach your app again. Its corrupted.

Regards

ASHFAQ

[krishna20]

i checked in straight table by taking calculated dimension if(CS_COMP_CODE='001' or CS_COMP_CODE='002'...........) and expression as SUM(CS_AMT_LC_1).

The total in DB and QVW is 3813767227

COMP_CODE : 001 total in DB is 1836772815.773

but i'm getting value for COMP_CODE : 001  is 1569389285.213

Regards

Krishna

[avinashelite]

Hi Kalyan,

I am not able to download the document?? how many MB file it is ?? its going beyond 40MB+

[krishna20]

Hi Avinash,

Its a 260MB file avinash.I'm uploading total file for you to guide me.

Regards

Krishna

[avinashelite]

Hi Krishan,

Use rowno() over CLM_Settlement table and check the data once.

like load ...,

Rowno() as serial_no

from qvd....

[krishna20]

Hi Ashfaq,

Pls find the below attachment and guide me further.Its very urgent,please do the needful.

Regards

krishna