Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
can anyone suggest me how to developed step by step multitired application in qlikview.
Thank You.
Hi,
let say 3-tier ,
Data source layer:
this section data loaded from database/other source and stored into QVD format.
Transformation layer:
here we do all kind of data cleaning,logical calculations, transformation based on our business requirement.
Presentation layer:
Using the Binary load the Qlikview file created in Tier II is loaded in to the Qlikview file and all chart objects are created in this Tier.
Check this article,
if i want to create more than 3 tier then what should i do?
Eventually, They developed Architect and Layers only till Binary Load ... That's called 3-tier architecture
At a high level I have the following Tiers/layers
Tier3/4: Data model and UI
Layer 4: Create data model (star schema) using data from previous layers
Layer 5: Binary load data model (Layer 4) into UI
More info explain 3tier architecture
Hi
Layer 1:
You Need to Load the Data in this layer and storing it into QVD.
Layer 2:
Using QVD(Which u have Created in Layer 1) u will Create the Data Model Here(Star,Snow Schema)
Layer 3:
Using Binary Load you will need to Call the Layer 2 QVW file and Start creating Your Dashboard.
ex:Binary Sample.qvw
Thanks,
If you have complex transformation which could not be handle with in 3 layers ...feel free to introduce a additional layer/tier to make the transformation that is totally fine ....here the QVD out of 3 tire would be treated as the input and you could create the final QVD's .....
we do have apps which are going through 5 to 6 level of transformation
how to do 5 to 6 level of transformation?
it depends on the complexity of the day what your dealing ...if you taken an example of trade data you need to apply 6 to 7 level of transformation on the data set ...In each tier the data is enriched and it will pushed as an input of the next level ...like Transformation 1 , 2, 3, 4, etc and the final QVD ...each tier QVD's will be used for different purpose
Hope you understand
can you describe this?
"We've used mostly 2-tiered QVD architecture for our bigger deployments. It's very useful for data reuse (when you have some sets of data, e.g. sales data, being used in more than one applications)."
can able to explain ur 5 Layers starting from layer 1