Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks
I'm new to QlikView i would like to know what is the middle-layer for Data Modelling in QlikView.
For example we have universe in SAP BO.
Thnaks & Regards,
Varun
Hi.
In QlikView we don't have any such layer.
In a way you can use qvd's to perform ETL/ Transformation part.
Regards
ASHFAQ
Hi
Thank you.
Regards,
Varun JM
Hi
You can build an intermediate data store in a data layer by using a set of QVD generator models (QVW files) that store QVD files for all your data sources. Then the business layer can build the models from the QVD files rather than going direct to the data sources.
This allows the combination of proper governance, control and scheduling of the queries hitting the data sources, and flexibility and consistency for the development f the final qvw files.
HTH
Jonathan