topic Generate Static reports using qvw and http request in QlikView

Generate Static reports using qvw and http request

Sun, 11 Mar 2012 20:44:28 GMT

Hi Guys,

I have a customer which has QlikView Server SBE and some Named User CALs.

The customer has several qvw documents.

The most important users, consume information directly from QlikView models (mostly throw Access Point), but more and more medium level managers are requesting also to consume information (static reports) from QV models.

Up to now, there was no problem retrieving those reports from QV models and sending them by email but, since the number of requests is increasing too fast, and there is no possibility to buy all needed licenses at the present time, our customer asks about implementing the solution below:

Using a tab in an existing web application, some authorized users will send http requests specifying the reports needed (specific QlikView model, FromDate, ToDate, etc). The web application will launch the specific QV model using Command Line (qv.exe /r /v document.qvw).

QlikView model will then output the report as csv file, to be later retrieved by the web application.

Although those medium level managers won't get QlikView abilities, but at least will get the possibility to have some static reports ad hoc without being dependent on IT team response time…

Is there any better, faster, cleaner and simple way to achieve the goal?

Is there any related license issue to be taken in care?

Is there any other recommendation?

Thanks in advance,

Aldo.

Generate Static reports using qvw and http request

disqr_rm — Sun, 11 Mar 2012 23:09:59 GMT

It seems to be good usage of PDF distributor. YOu can define dynamic reports to take input values from application variables which would get set from some sort of text file created by your http request from users, and then using QMS APIs you can trigger reload jobs which would generate PDF and send them emails.

But this will cost a Publisher and PDF Distributor licenses.

Generate Static reports using qvw and http request

Mon, 12 Mar 2012 09:15:11 GMT

Hi Rakesh, thanks for your answer.

A couple of questions.

QMS APIs - Do you mean QlikView Server Distribution Services?

Since users need to do their own taks on report's data, pdf format is not a good option.

Any other idea?

Thanks,

Aldo.