Takeaway

You should now know how to enhance SAP HANA information views with the eight different modeling features we’ve discussed in this chapter.

You have learned how to create calculated and restricted columns to add additional output fields to your information views. You have looked at filters and filter expressions, and learned how to limit the data early in your modeling process.

You can now identify when to create variables and input parameters to allow business users to specify what outputs they want to see in the result sets of your information views at runtime.

Working with currency, you now understand how to add currency conversions to your financial reports. You can now describe decision tables, how to create them, use them, and what value they can add to your business users.

Finally, your now know how to create hierarchies to provide powerful drilldown capabilities for your end users.