We’re completing our SAP HANA series with an exploration of analytic privileges—covering general security and how to practically apply analytic privileges to restrict the data a user sees from the created models in your workspace.

In this fifth session, we will continue working with calculation views, specifically learning how to improve them for queries that use different techniques, for example, Union Pruning and Static Cache.

Today we’re building on the work we did in Part 3, and learning how to take advantage of the configuration and structure we defined previously in order to model data in Instance 1 that is contained in Instance 2.

In this session, you will learn how to create and manage users including the creation of roles, certificates, remote sources, and so on. The steps we will run through in this article are critical before we continue with the series, as it's vital that your configuration is correct in order to work with database artifacts contained in an external instance.

In this article, our main goals are to define table structures and roles, and then we’ll explore how to import data to the development space that we explained how to create in Part 1.

More and more organizations are realising the key role that data analysis plays in maintaining a competitive edge and meeting their strategic goals. But as the volume of data grows, the pressure on budgets increases, and the need for real-time analysis to allow data-driven decision making becomes ever more crucial, on premise data management solutions struggle to cope.