Developement and Productive QVDs Sharing

[#1]

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

[#2]

Any People working with SAP and Qlikview will be able to answer I guess.

Thanks

sravan

[guytzumer]

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 )?

[martinpohl]

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

[#5]

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

[#6]

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