Architecture

[prabhas277]

Hi expets,

What is the use 3 tire architecture compared to 2tire in qlikview.

[tamilarasu]

Hi Prabhas,

Check the below link,

what is qlikview architecture? what is 1-tier arc and 2-tier arch?

[ashfaq_haseeb]

Hi,

Hopefully this will help you.

3 Tier Architecture + QDF

Regards

ASHFAQ

[Anonymous]

Basically we use to follow 4 tier in most of the cases like:

In First Tier:

Data is loaded from the Database and stored in QVDs(Raw Level)

In Second Tier:

Data is loaded from QVDs and tranform the data based on business needs(Transform Level)

In Third Tier:

Load the Transform Qvds and Create the Data Model Level

In Fourth Tier:

Using the Binary load the Qlikview file created in Tier 3 is loaded in to the Qlikview file and all chart objects are created in this Tier(UI Level)

If summarize, we get:

1) Data Layer(Raw & Transform)

2) Business Layer(Metrics & Relationship)

3) Presentation Layer(DAR Concept)

For More Details, see:

Three Tier Architecture

[ramasaisaksoft]

Hi Prabhas,

three-tiered QlikView environment:

• Tier 1 application files are the data connection layer. The QVW connects to the database and runs the SQL queries of database tables to generate QVDs.

• Tier 2 is the transformation layer where transformations are performed by tier 2 QVWs with data from tier 1 QVDs. This information is stored in tier 2

data model QVDs.

• Tier 3 is the GUI/presentation layer, which uses tier 2 QVDs for the data model.

[#6]

[mohammadkhatimi]

Hie...

PFA

Hope this will helps you...!!

Regards,

Mohammad

[ChennaiahNallani]

Hi Prabhas,

If you are dealing with large amount of data set. we need to implement incremental load to updated qvd's. so in this case

we can implement 3 Tier architecture.

1st tire   :  we extract data for DB and store in to QVD's and Implement incremental load.

2nd tire  :  we can build Association model based in Client requirement and store in QVD'S.

3rd tire   : user 2nd tire QVD's we design GUI.

[#9]

Hi,

In 2 Tier, all the Data Extraction is done and stored in QVD files in one Qlikview file and Transformation and Presentation using QVD files generated in previous file are done with in another Qlikview file.

In 3 Tier, Data Extraction is done and stored in QVD files in on Qlikview file, Transformation is done using Qlikview files in another file, Presentation is done in another file using Binary load of Transformed Qlikview file.