Summary

We learned how to work with calculated columns, restricted columns, and filters in our information views. We added variables and input parameters to add a new level of dynamic interaction to our modeling by allowing the end users to specify what they are looking for in each query of the SAP HANA information views. We also saw how to enrich our information models with currency conversions, decision tables, and hierarchies.

In the next chapter, we will discuss how to use SQL and SQLScript to provide the advanced features that you (occasionally) might not be able to do with the graphical calculation views we discussed in previous chapters.