beeye::getBeeyeQvReportList

Code Sample :: PHP

Usage

This function is a helper, to get a list off all Report Objects inside the specified document

Datasample

DocName ObjectName Report Name
c:/QlikView/Online Sales.qvw Report\RP1 This is my Sample Report
Online Sales XML

Dynamic Forms

Why dynamic Forms?

You might as, what is the reason for building dynamic forms in QlikView? Well, the reasons are:

  1. QlikView is a analysing tool, now real logiq is build in to UPDATE date
  2. QlikView doesn’t know the logiq, which datapoints are needed to UPDATE data – you need a place where you can define the KEYS
  3. Workflow is needed to commit, approve and apply UPDATES

So to fix those open issues, I come to the point where a form generator is needed where you can manage the KEYS, WORKFLOW and finally the UPDATE to the original source. Checkout our latest version of beeyeQvService and you’ll find the first beta of the tool;) And after this post I will write a short How-To on how to implement it in your QlikView enviroment…

DynForms Manager Admin
DynForms Admin View

 

beeye:getbeeyeQvFieldList(_DocName)

Code Sample :: PHP

Usage

This function is a helper, to get a list off all Fields inside a QlikView Document. Currently sorted by creation order inside the load skript.

Datasample

DocName FieldName
c:/QlikView/Online Sales.qvw ProductId
Online Sales XML

Testing the Service with SOAP-UI

After you have installed the service, it could be usefull to test the functionallity! We suggest to use the community or commercial version of soapUI, which can be found on sourceforge…

I work with the latest Version 3.6.1 delivered as WindowsEXE.

Manage Organisation Groups

NEW Feature!!! (2011-04-11)

As it is sometimes neccessary to manage user groups, which will recieve the same report with the same settings. I’m proud to announce the new feature in the User Management, which allows you to define a Organisation as a group. This is done at the to, next to the salutation.

After you have activated this feature, you need to reload the page, to get the correct input view:

tutorial_user_groups

As you can see, you can now add several users with the related communication information. Notice! You are allowed to add a user several times, as you send e.g. a mail to different adresses;)

Feedback welcome!

„Manage Organisation Groups“ weiterlesen

Manage Communication

Manage Communications

After you have created a new user, you need to add the information on how to deploy the reports generated by QlikView. This can be done by a click on the update (PENCIL) symbol in the admin interface, which can be found here:

tutorial_organisation_admin_detail

After that you will get forwarded to the organisation detail page – as it is now no more a new user, at the bottom you will find a new area, where you can manage the different communication options for the user, available parameters are:

  • E-Mail : info@beeye.org
  • Share: \\192.168.0.1\public\reports\user
  • Fax: 0049 711 852505@faxgateway.com

If you are interested in an individual deployment, tell us about! At the moment, we think this will fit most of the common needs.

To create a new communication, you’ll find a link <<new communcation>> at the bottom of the page:

tutorial_communication_new

Qv Service Manual

by Philipp Frenzel (info@beeye.org)

beeye Qv Service is a wrapper class for some of the basic OCX-Methods from QlikView to SOAP. Feel free to implement it in your own solutions or use my yii based (webbased) solution.

For those who don’t know qlikview, they can take a look at www.qlikview.com where you will find a lot of useful informations to this perfect in memory analysing tool. (Business Intelligence) As it is the best tool for dynamic dataanalysis, the report generation and distribution is not really usable. For a lot of money you can buy the qlikview distribution server with the print functionality but specially for SMB-companys it’s not a way to go. As I work for such an SMB I build this solution in my „free“-time and share it to you over this blog. Feel free to use it and take care about the license;)

There will be an enterprise version of the service that has the following advantages:

  • better performance
  • direct access to QlikView Server (now console application and open qlikview client is needed)
  • connectivity to individual datasources