Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
have u replaced the QVD's also? what is the frequency of refresh?
-Sundar
yes ,same
i replaced everything
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.
how i can verify whether they changed the date format
Do ,the change n the date format effect the financial year
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?
they don't want to give rights in oredr to directly access SAP
Why do you not use SAP Connector to extract data from SAP instead of Oracle? QlikView can extract data from SAP quite effectively.
security reason
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