Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
By using Qlikview expressor can we combine more than one QVW data models and create a new report ?
Thanks,
Chiru
Hi Chiranjeevi,
Expressor is a data integration tool with a semantic framework and primary purpose is to manage deployment, data and metadata. It maintains data consistency with all applications and offers a reusable version which is controlled in repository to reduce development time. I am attaching a link for your reference, please have a look on it, I hope this is informative and helpful.
http://community.qlik.com/blogs/qlikviewdesignblog/authors/mto
Regards
Advait
Hi Chiru,
QlikView Expressor (QVE) provides data governance and data management within a QlikView environment; providing visibility and data confidence in QlikView deployments. It strengths enable the creation of a single conformed data management layer that can be used to drive QlikView applications.
QlikView Expressor has also been used as an ETL (Extract Transform Load) / data integration tool to supplement other data preparation needs such as the creation of various data stores. This is common in a setting where other ETL tools are not available.
QVE can help consolidate multiple data sources, augment data and create a data store/mart/warehouse to be accessed by QlikView and other applications. Other benefits of QlikView Expressor include its ability to graphically prepare and control the flow of data while storing, sharing and reusing various components of the development process.
Thanks,
Varun Bhat
Yes, Expressor is an ETL tool.
No, Expressor cannot directly combine multiple qvw data models into a single data model.
The general flow (with or without Expressor) to combine qvw models is:
1. Binary load the qvw.
2. Store each Qlikview table in the model to a QVD.
3. Load those QVDs into a new,merged QVD.
NOte that because of the restriction that a script may contain only one binary statement you can't process the above in a loop over multiple QVWS. You have to build a separate script for each qvw, or alternatively, store the QVDs in the script that builds the model.
Rob