Our spin-off for business planning and simulation with Jedox.
Florin AG relies on Qlik Sense to analyse SAP data for use cases in controlling, in the laboratory as well as in production and human resources.
The modern function library for Process Mining with Qlik Sense and Power BI
The iVIEW Library is a standalone web application for managing and deploying master data items and content definitions for Qlik. The user navigates through a central library and selects content that can be deployed to one or more Qlik applications. Data items or variables can be easily can be easily added, edited or deleted and assigned to Qlik Sense applications. A next level of self-service for all Qlik users, allowing them to populate applications with content, generate them ad-hoc and much more.
What if BI specialists could share content and KPIs with other applications and with their target audience? If data could be detached from singular contexts, its significance recognised and it could also be used for other, new analyses? Without changes to the code, without searching for formulas or algorithms?
The iVIEW Library meets these requirements completely: all KPIs and calculations are stored in a simple and clear web application. All meta-information is recorded in detail and easily accessible. No one needs to access individual Qlik applications anymore to extract data, dimensions or calculations. Instead, users find this information structured and can use it intuitively.
Additional advantage: Cataloguing can be used dynamically in all Qlik applications. If a measure is adjusted, recalculated, provided with additional metadata or categorised differently in the iVIEW Library, this change has a direct effect on all applications in which this measure occurs.
Such comfortable BI workflows are not possible with Qlik "naked", but with the iVIEW Library, which optimally exploits the potential of the integrated Qlik APIs. The iVIEW principle maximises the added value of every BI solution by allowing applications to be populated directly with KPIs or dimensions (self-service). This makes the library a performance tool par excellence and catapults user companies into new ROI spheres.
The lifecycle of Qlik Sense applications is determined by the acceptance of users. Translate data into consumable and readable information. iVIEW Library helps you generating and managing this content: KPI definitions, descriptions, metadata to fields, variables etc.
Master data is often encapsuled in a single Qlik Sense application. But what if I could share content and KPI’s with other applications? Scale out your knowledge and deploy to any application in seconds with iVIEW Library.
Self-service is not only design new charts. There is the need to reuse data models for ad hoc analysis, try new things, sand-boxing, get to know data! iVIEW Library enables you to select data models, populate an empty app with data, master items and definitions.
A web-based application offers you an overview of your Qlik environment, dividing it into streams, data models and final UI applications. Your rôle is to define data items, such as dimensions, measures, variables, field tags, field and label translations etc. Look at this master data as your global catalog – assigning a business or semantic context to your technical definitions, through a simple, lean web interface.
Qlik offers API’s, we actively use them.iVIEW Library fully integrates into Qlik’s functionality. It’s about automating processes and tasks, that are usually done manually with Qlik’s native interface. Avoid « copy/paste » actions to transfer logic between applications.
Your users need readability, autonomy and freedom defining their content. Let them work on predefined data models and ensure the usage of globally accepted master data, as for KPI expressions. You can easily generate an overview of your master data throughout your Qlik environment.
As a Qlik Sense user or developer, it is important to be able to access existing content in Qlik Sense applications and import it into the central repository in a controlled manner.
One scenario could be that an application is newly developed, new data and subsequently also e.g. new KPI definitions have been created. The developer can now transfer the new content into the iVIEW Library in this way.
Another scenario would be ongoing changes so that I can replace the definitions from the iVIEW Library with the changed content in the existing Qlik Sense applications.
A key functionality in the iVIEW Library is the ability to push content from a central spot to the various Qlik Sense applications. This is even across Qlik Sense servers.
The iVIEW Library thus acts as a single point of truth.
In addition, the iVIEW Library offers something unique: this central content can be "subscribed to". The so-called "subscription" provides a direct link between an item (KPI, dimension, variable) and one or more Qlik Sense applications.
As the previous use cases show, the iVIEW Library offers powerful functions to interact with Qlik Sense applications and thus distribute and use content in an optimal way.
But this shared knowledge needs to be tested and learned. For this purpose, the Library offers the possibility to generate an app "on the fly", to fill it with data and to provide it directly with items. This can be done without even having to create an app.
All this without even opening Qlik. How does this work?
In App Management, I can create a new app, name it and assign an existing data model to this app as a basis. In addition, the user can also determine on which Qlik Sense server the new app should be generated and, if necessary, published.
With the "Reload" function, the app is reloaded. From here on, the developer can give free rein to his creativity.
For items to be successfully distributed to Qlik Sense, there must be a direct dependency between the items managed via the iVIEW Library and the underlying data models and applications.
To address this, the iVIEW Library provides for direct mapping of Qlik Sense applications to centralised content.
A list of "compatible" Qlik Sense applications can be maintained via the metadata of each item, so that the affiliation to these applications can be checked before the content is distributed by the deploy action.
For the data storage, you can choose between an embedded database (H2) and MS SQL Server database when installing the iVIEW Library. The latter serves as a repository and as a persistence layer.
The size of the database correlates directly with the size of the Qlik Sense infrastructure and how intensively the content is centralised. Basically, only metadata is held here. Experience shows that the size is in the small to medium MB range.
The database is openly accessible for read access, so that further analyses can be carried out.
For the Qlik content, the library follows the security concept of Qlik itself 100%, i.e. the user only sees as much as in Qlik. This includes and takes into account the implemented security rules as well as the "Admin Roles" that are configured in the Qlik Management Console (QMC).
The iVIEW Library implements Keycloak as an authentication and authorisation module. An LDAP connection is provided by default. However, authentication can be extended to other methods and protocols, such as SAML, OAuth2, etc.
For authorisation, the iVIEW Library relies on two basic roles: Library User and Library Admin. The model can be extended to the individual functions of the iVIEW Library. For example, roles for Deployer, App Manager and Library Owner can be easily implemented.
In our On-Demand Webinar, you will learn how to comply with modern data governance in your Qlik BI environment. Thanks to the centralized and automated management, generation and provision of master items in all applications, the self-service approach can be further strengthened.
BI Consultant Eunice Branco in an interview with Danijela Essia (Project Manager Marketing) about the advantages of "iVIEW Library".
To better understand the potential of the Library, the functions and structure of the platform are essential. To help the user navigate and model the content, the iVIEW Library is divided into the following sections:
Create, Edit, Clone, Delete, Origin app detailed view, Deploy now, Check subscriptions, and Manage subscriptions
In this area, the user can perform various operations with his master items (dimensions, key figures, variables). All essential operations are available via right-click or via the Group Edit functions.
Create, Edit, Clone, Delete, Go to app detailed view, Publish, Open app, and Reload
In this area, the user can manage applications and their master data or metadata without having to call up the QMC. Three tabs are available for this purpose: App Overview, App Detailed view and Subscriptions.
Import now and Delete
Under "App Detailed View" the user finds a Qlik Sense "Explorer". This provides a full overview with all server connections, streams and apps. When selecting a specific application, the user gets an insight into the items and variables available there. The items can now be imported into the central library. This area can also be used for a "clean-up" of the application.
Check subscriptions, Subscribe, and Unsubscribe
The Subscriptions section contains the core functionality for distributing centralised items to the various Qlik Sense applications. The simple deployment distributes the content once. The subscription creates a link between the item and an application - this can be deactivated via "Unsubscribe".
Create, Edit and Delete
For Qlik users, it is not a foreign concept. Tags allow users to organise their data more efficiently by associating elements with tags. These are user-defined keywords that assign meaning to a group of elements and can be used as a basis for sorting / filtering.
License, Connections, and Export/Import data
The configuration includes 3 areas: Entering the licence key (usually a one-time action during installation), the server connections for different Qlik Sense servers and the possibility to export the library contents to a dump file and to import them from a file.
Complementing the project-related use of iVIEW, Informatec develops BI products & solutions for specific, standardisable customer and market needs on the same platform.