We have many articles available to talk about performance tuning in HANA models and even so many articles for best practices too.
This document something will deal about importance of building blocks (base views) and how to build the model with base views and how that support and reduce the time when there is any major or minor changes in that model.
For example,
We have built a calculation view using 4 to 5 projections and joins. On top of the model, we have built variables which will act as a prompt in Reporting tools like Web Intelligence, Crystal Reports, Explorer, etc.
In Future, if there is a changes in the applied logic as we need to modify the tables or need to add new tables then it will take more time to modify the model to accommodate the new logic if the existing model is simple and without any building blocks.
Consider we have model like below, we need to add new table after Join_2.
If we got new Requirement from Client as like below,
Following changes required,
To avoid the above steps, we can have this model with building blocks.
For the above tables I have created a 2 building blocks, building blocks is nothing but the base views.
The above view 1 is used in projection_1 and View 2 is used in Projection_2.
If we got new update to add new table KNA1, then we add that in base view 2 and we can select only the fields in main model.
It will not affect the naming conventions or variable mappings.
Always do the naming conventions in base level itself.
Thanks and let me know, if any further explanation needed on this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |