Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Symantic Layers

Hi All,


Can you please explain what is Symantic Layers in QV.

Thanks,

Sukumar.

1 Reply
neetha_p
Honored Contributor

Re: Symantic Layers

Hi Sukumar,

Semantic Layers are more of Business Objects concept. Semantic layer can effectively be achieved by creating a QVW which implements the data model and row level security, but does not contain any UI elements. These "data model" QVW's (conceptually the same as a BO universe) can be reused in various QVW applications which implement the user interface. The "data model" QVW can be loaded into the UI using a Binary load statement.

There are a few minor limitations with this approach in that you can only perform a single binary load statement in a given QVW, and that by taking this approach you are effectively increasing your IO (you need to write the data down once to the "data model" QVW, and then again into the UI QVW's n times).

Qlikview architecture when 3 tiers implemented, we can achieve this:

In First Tier:

Data is Extracted from the Datasources and stored in QVDs.

In Second Tier:

Data is loaded from QVDs and transformation of the data is done based on business needs and data model is created.

In Third Tier:

Using the Binary load the Qlikview file created in Second Tier is loaded in to the Qlikview file and visualization is done using all chart objects in this Tier.


Regards

Neetha

Community Browser