Restricted Column is a very cool feature in the SAP HANA Modeler which can be used to restrict a measure based on certain conditions of the master data. This helps when it is known that some queries will get fired more often than others (due to business requirements) and that these queries are based on an underlying subset of data which has certain restrictions applied. Rather than make the front end client do the processing work of applying the restriction, it makes sense to push this to the database layer (i.e. to HANA); especially if the number of records in the subset is very high and if the chances (driven by business) of these queries/reports is high.
The video below will show you how to create a Restricted Column and will also show how one can do an analysis preview in the Data Preview Editor of the SAP HANA Modeler on data in this Restricted Column.
If some of you find the UI of the HANA modeler different to what you are used to seeing, its because I have used the SP5 HANA Modeler version. Please see the half an hour video that I created at this link to see the UI improvements in the HANA Modeler with SP 05. This link can also be fount by going to the "Implement" drop down tab on this page --> "Implementation Resources" --> "HANA Technology" and search under "All" for "New Features with SAP HANA Modeler SP5".