Qlikview cache memory

[#1]

Hi all,

I need to load the same view several times for different reports ue to security reasons.I am loading the same view under different table names for different reports.How can i avoid loading the views several times?Please help.Thanks in advance.

[sparur]

Hi, Sandhya.

You can use a RESIDENT statement. For example,

table1:

Load * ;SQL SELECT * FROM [SQLTable];

table2:

NOCONCATENATE LOAD * RESIDENT table1;

etc...

[#3]

As explained above ..This can achived using the RESIDENT Stament in LOAD.

[#4]

Thank you.

I am not able to reload the qvw files through Qlikview 9 server.its showing Oledb Connection failed error.But i am manually able to do it and also in qlikview 8.5 server.Can you please suggest me what might be the error.I get password as REMOVED even thogh the connection string has a valid password.

Please help.

[#5]

Thank you.