topic Re: QlikView Project Tiers/Layers in QlikView

QlikView Project Tiers/Layers

nihhalmca — Wed, 12 Aug 2015 13:13:57 GMT

Hi All,

Which scenario will go for 3 Tier - Stage 1 (Basic Qvds), Stage 2 (Intermediate Qvds), Stage 3 (Final app)

Which scenario will go for 2 Tier - Stage 1 (Basic Qvds & Intermediate Qvds), Stage 2 (Final app)

Which scenario will go for 1 Tier - Stage 1 (Final app)

Can anyone share knowledge on this with little examples.

Regards,

Nihhal.

Re: QlikView Project Tiers/Layers

Clever_Anjos — Wed, 12 Aug 2015 13:24:28 GMT

I would recomend you participate this group : QlikView Deployment Framework‌

Re: QlikView Project Tiers/Layers

MK_QSL — Wed, 12 Aug 2015 13:28:15 GMT

Use this

Re: QlikView Project Tiers/Layers

jagan — Wed, 12 Aug 2015 16:21:58 GMT

Hi Nihhal,

No sample, but you can create yourself.

I Tier:

All Load script, Transformation and Presentation (Charts) in a single Qlikview file.

II Tier:

First QVW File: Pull data from Databases/DataSources and save it in QVDs.

Second QVW File:Create the Datamodel and apply business logic and create the Presentation (Charts) in this Qlikview file.

III Tier:

First QVW File: Pull data from Databases/DataSources and save it in QVDs.

Second QVW File:Create the Datamodel and apply business logic

Third QVW File: Binary load the second qlikview file and create the Presentation (Charts) in this Qlikview file.

Hope this helps you.

Regards,

Jagan.

Re: QlikView Project Tiers/Layers

qlikviewwizard — Thu, 13 Aug 2015 06:39:00 GMT

Hi Nihal,

Please close the thread by selecting correct answer and helpful. Thank you.

Re: QlikView Project Tiers/Layers

nihhalmca — Fri, 14 Aug 2015 09:53:36 GMT

Hello,

If i get solution, i will close post. do not worry.

Re: QlikView Project Tiers/Layers

nihhalmca — Sat, 22 Aug 2015 10:33:53 GMT

Hi Jagan,

Thanks for response and i know about layers, however my question is

Which scenario will go for 3 Tier And

Which scenario will go for 2 Tier And

Which scenario will go for 1 Tier

Please see my original post.

Thank you.

Nihhal.

Re: QlikView Project Tiers/Layers

jagan — Sat, 22 Aug 2015 15:04:42 GMT

Hi,

Tier 1:

If you are using some data in only one Dashboard then you can do all Extract, Transform and load in the same file.

Tier2:

If you are using some data in multiple dashboards then create two layers, data extraction in one layer and Transform & Presentation in same layer (if you are not using same datamodel in any other dashboards then use this type).

Tier 3: If we are using same datamodel in multiple dashboards then use this pattern.

In general follow the 3 tier pattern in all the Dashboards so that it would be easier to understand.

Regards,

Jagan.

Re: QlikView Project Tiers/Layers

Anonymous — Sat, 22 Aug 2015 15:32:21 GMT

hi nihal,

1 Tier architecture is least preferable for performance and maintenance wise.

suited for Smaller data sets.

so raw data is extracted ,transformed and data model is created and visualization in same layer

2 Tier architecture and preferred for Smaller data sets.

Raw data is extract in first layer,

transformation ,data model and visualization is done in second layer

3 Tier architecture is most preferable for performance and maintenance wise.

suited for Larger data sets.

so raw data is extract in first layer,

transformation and data model is done in second layer

and visualization is done in third layer .

Regards

Neetha

Re: QlikView Project Tiers/Layers

nihhalmca — Sun, 23 Aug 2015 14:21:17 GMT

Thanks Jagan.