Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

swarup_malli
Valued Contributor

Best practices for the administrator of Qlikview server?

Hi,

  I'm rookie when it comes to administering  qlikview server.

  Currently I'm working with Qlikview 11 enterprice edition.

  What are the best practises a administrator should follow ?

Thanks

MS

6 Replies
swarup_malli
Valued Contributor

Re: Best practices for a Qlikview administrator;

Some of the best practices, I know and would like to share with fellow QVS administrators are :.

  • 1)      Never copy  qvw into root folder cos it contains  pgo files ,they are like configuration  files.
  • 2)      Everything on mounted folder.
  • 3)      Always create task groups, this will avoid confusion when you have huge number of tasks
  • 6)      Minimize the use of input fields.
  • 7)      Not a good practice to let the users add objects via access point uses up memory.
  • 8)      Not a good practice to let users download documents ( bandwidth usage)
  • 9)      Limit the number of rows in export ie if a table has 60 million rows and users exports them..ie 60 million not good, limit it to 1000 or something.
  • 10)   The share collaboration feature eats resources.
  • 11)   Put all the source qvd,include files and images in source document, maintain 1 source for 1 qvw and place qvw on the user document.
  • 12)   When you delete a qvw delete all tasks associated with it and free all the document cals associated with it.
  • 13)   QVS detector
  • 14)   QVPT
  • 15)   In qvs 11 you can do extraction from the server itself, meaning you don’t have to create a separate extraction qvw .
MVP
MVP

Re: Best practices for a Qlikview administrator;

Hi,

Although some of them are best practices for developers, I shouldn't agree with many of the points you list above, depending on what the user is expecting from the tool.

Downloading is not a best practice. Ot because bandwidth, but mainly because the cost and time of installing and configuring QlikView Desktop in each computer.

Sharing objects will use a small amount of disk and memory, but it can provide users with a powerful tool to build their own analyses.

It's always best practice to have QVW to control what you extract and create tasks from those files.

Source/User documents is used by Publisher, it distributes if you set up a task to do so.

If you have a chart displaying 60 million rows, I'd say that something is wrong in the model or analysis (I mean, you really need 60 million rows in one chart? There is no way to analyze that!)

Etc...

I'd recommend you to go to the QlikView site, training, and follow the several free documents and videos you have.

Hope that makes sense.

Miguel

swarup_malli
Valued Contributor

Re: Best practices for a Qlikview administrator;

Thank you Miguel, The points were very helpful

gainkarthi
Valued Contributor

Re: Best practices for a Qlikview administrator;

Miguel,

Do we have any document for this?.

Regards,

Karthi

Re: Best practices for the administrator of Qlikview server?

... and don't forget the 3 B's :

          Backup, Backup & Backup.

dmohanty
Valued Contributor

Re: Best practices for the administrator of Qlikview server?

Do we have any Best Practice Document for QlikView Server Management?

Any PDF or PPT?