Urgent (Issue)

[#1]

I have one application named as finance it fetch the data from Oracle .

there data comes from SAP then dump into Oracle, last week while dumping from SAP into Oracle ,their SAP team face some issue called mirroring( i dn't know ,what it is & its consequences)

Now QLikview  showing incorrect data , but when check in the backup data is correct ,

Once ,I replace the main folder app with backup and qvd generator with backup qvd generator  ,qlikview  populate incorrect data

Data of 2013-2014 displayed in  2012-2013

Any idea ,how to resolve this prtoblem

[sundarakumar]

have u replaced the QVD's also? what is the frequency of refresh?

-Sundar

[#3]

yes ,same

i replaced everything

[vinay_hg]

just cross verify the logic date filters you have used. i mean 2012-2013 or 2013-2014. if this is correct then check the date filed which you are using to arrive this financial year format. according to me in the db the date might got updated with wrong date (data) so urs value may differing in case if u used proper date formatting. u need to check in oracle db for data is there any change in date format  or date value.

[#5]

how i  can verify   whether they changed the date format

Do ,the change  n the date format effect the financial  year

[vinay_hg]

check in the extract or while u created raw qvd, which format date is coming. yes this will effect if incase as u tols while mirroring all 2014 dates if got updated to 2013 or 2012 due to some issue as u mentioned earlier sap team faced some issue. secondly if your date reading format is wrong then also possible.

tell me 2012-2013 means from jan2012 to dec2012 or apr2012 to mar2013?

[#7]

they don't want to give rights in oredr to directly access SAP

[senpradip007]

Why do you not use SAP Connector to extract data from SAP instead of Oracle? QlikView can extract data from SAP quite effectively.

[#9]

security reason

[sundarakumar]

reload freuency pls. bec the issue is with data not with Qlikview. if the relaod frequency is 30 mins then ur replaecement would be a gone within next  half an hour.

-Sundar