Agile planning and actionable location analytics for your Qlik platform

Leverage K4 Analytics and build the missing link between your preferred BI platform and Enterprise Databases, contributing to your Corporate Performance Management.

No more spreadsheet anarchy and finally effortless real-time data consolidation: you will continue to use your Excel models but we will make them dynamically integrated with the data-sources, with the ability of editing the data and saving back on the fly to the central database(s).

Enjoy Smart Data-Entry, master numbers and simulation thanks to rich features such as blocked totals, copy from, allocation drivers… Just add full audit trail, integrated workflow control and real time collaboration, this is K4 Analytics!

What can you do with K4?

K4 allows you to leverage all the flexibility of spreadsheets inside QlikView and Qlik Sense. Using an Excel© file as a template, keeping all the formulas and the formatting, K4 dynamically fetches data from Qlik dataset and SQL live queries to populate the Excel template.

By using K4 you can manage a simple P&L statement with amazing speed and simplicity: just build the template in Excel, link cells to data and use it inside Qlik, users are not required to have MS Excel installed.

And it doesn't stop there ... you can even enter data, text, date, checkbox and drop lists in K4, saving on the fly to a SQL database!

In a very simple way you can lock data (disable the data-entry) on a cell-by-cell basis through a Qlik or a SQL expression. You can display actual data for closed month and editable cells for planning months.
The locking logic can be as complex as you need taking into account for example the current date versus the planning calendar and the current user versus the hierarchies.
You can manage a distributed planning process with multiple users entering data in a common database with full control thanks to K4 Audit Trails feature.
K4 does not come with a predefined business model, you can use it to build exactly the application you need.

How does K4 work?

The K4 solution is made of two components: the Qlik extension object and the web service.

The extension object loads data dynamically from one or several Qlik datasets or one or several SQL queries and merges them into an Excel file used as a template.

If K4 is configured for data-entry, when the user hits Save the new/changed data is sent to the web service which takes care of writing them in a table in a relational database. The data is then read back on-the-fly from the SQL database when the object is refreshed. (and eventually loaded back into Qlik with a reload).

You can use the K4 object in a document opened with the browser (AJAX client) from the Qlik access point or opened with the Desktop client (in QlikView in WebView mode). MS Excel is not required on the clients.K4 uses its web service for write-back. The web service receives from the K4 object the new/changed data together with the Qlik document current selection and the user id: it compares these data with the structure of the buffer table to check that it has all the information (e.g. primary keys) it needs to create/update records in the buffer table.



Demo Highlights






RELATED RESOURCES
WitSide_K4_Flyer
 

CONTACT US
Αυτή η διεύθυνση ηλεκτρονικού ταχυδρομείου προστατεύεται από τους αυτοματισμούς αποστολέων ανεπιθύμητων μηνυμάτων. Χρειάζεται να ενεργοποιήσετε τη JavaScript για να μπορέσετε να τη δείτε. Αυτή η διεύθυνση ηλεκτρονικού ταχυδρομείου προστατεύεται από τους αυτοματισμούς αποστολέων ανεπιθύμητων μηνυμάτων. Χρειάζεται να ενεργοποιήσετε τη JavaScript για να μπορέσετε να τη δείτε.
 

Latest Tweets