Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
The scenario is this:
Development Server:
QVD Generator generates the QVDs based on the SAP Productive Data
Productive Server:
QVD Generator generates the QVDs based on the SAP Productive Data
Now as it happens two times in a night the SAP Productive Server has a lot of Load as parallel jobs from Dev and Prod are asking for the Data .
Now the Idea is to load the data only once on the Productive QV Server and then get the data into Development QV Server. Did anyone had the same scenario. Is there any recommended suggestion from Qlikview?
Thanks and regards
Sravan
Any People working with SAP and Qlikview will be able to answer I guess.
Thanks
sravan
Needs better explanation..
Does that mean development environment and production environment for QlikView or SAP .. ?
If you are fetching the same data in SAP production server ,- keep them in one environment and copy them by Batch file to the second environment
Although I do not understand why should maintain double-source data (QVD's From the SAPenvironment )?
Hello sravan,
store the datas into the development and also into the productiv server so you have to read them only once from your system.
Copy the store line and replace thethe server name and foldername(s).
MARA:
sql select * from MARA;
store * from MARA into \\server1\folder\MARA.qvd;
store * from MARA into \\server2\folder\MARA.qvd;
drop table MARA;
Regards
Hi Guys,
Very late to reply but thankyou for your answers.
Was now working on this Problem again after a long gap.
Does that mean development environment and production environment for QlikView or SAP .. ?
I meant for Qlikview.
Although I do not understand why should maintain double-source data (QVD's From the SAPenvironment )?
I need the data for further Development in Development Server of Qlikview
@ Martin
Your idea seams to be good. Thankyou
I still wonder why my procedure does not work
My procedure is as follows:
The Tables from SAP are stored in a folder X of the Productive environment of Qlikview
In the Development environment of qlikview the folder X can be seen and connected.
I created a Qlikview application in the Development Enviroment of Qlikview and can use the Data from Folder X
like this and can also reload.
Test:
LOAD ...
.........
FROM
X:\....\SAP_Common\MARA.QVD
(qvd);
now when I plan the task in the QEMC and reload it gives an error
Error: Cannot open file 'X:\....\SAP_Common\MARA.QVD'
10.08.2011 14:30:59: General Script Error
10.08.2011 14:30:59: Execution Failed
10.08.2011 14:30:59: Execution finished.
Any idea where to change the settings?
Thanks
Sravan
My procedure is as follows: The Tables from SAP are stored in a folder X of the Productive environment of Qlikview
In the Development environment of qlikview the folder X can be seen and connected.
I created a Qlikview application in the Development Enviroment of Qlikview and can use the Data from Folder X
like this and can also reload.
Test:
LOAD ...
.........
FROM
X:\....\SAP_Common\MARA.QVD
(qvd);
now when I plan the task in the QEMC and reload it gives an error
Error: Cannot open file 'X:\....\SAP_Common\MARA.QVD'
10.08.2011 14:30:59: General Script Error
10.08.2011 14:30:59: Execution Failed
10.08.2011 14:30:59: Execution finished.
Any idea where to change the settings?
Thanks
Sravan
can anyone please give an idea for the quoted problem of mine?
Thanks in advance
Sravan