Blocking natural persons data in analytics

A system comprising:

• at least one processor;
• and
• at least one memory including program code which when executed by the at least one processor causes operations comprising:
• receiving, at a data warehouse, a query from a server device including a model repository storing a database view, which in response to a client device request for a report, causes the query to be sent to and received by the data warehouse to enable blocking certain natural persons data, wherein the query obtains data for the report being generated for the server device, wherein the database view comprises a pre-defined database view stored at the model repository at the server device that is separate from the data warehouse, wherein the pre-defined database view is configured to send one or more pre-defined queries to the data warehouse to obtain the result set;
• processing, by the data warehouse, the query to identify data responsive to the query;
• evaluating the identified responsive data to determine whether there is corresponding metadata indicating a portion of the identified responsive data includes blocked natural persons data, wherein the metadata is stored at the data warehouse and is linked to the identified responsive data;
• when the blocked natural persons data is determined, evaluating the corresponding metadata to determine whether the block is a total block or a partial block, wherein the partial block allows key figure data, included in the identified responsive data, to be included in a result set, the key figure data providing an accurate numerical answer despite the partial block;
• in response to the partial block being determined, generating, based on the evaluated metadata, the result set including a predetermined value to mask the blocked natural persons data and to prevent the blocked natural persons data from being transmitted from the data warehouse to other devices including the server device, wherein the result set further includes key figure data associated with the blocked natural persons data;
• in response to the partial block being determined, providing, to the server device, the generated result set including the predetermined value to mask the blocked natural persons data and further including the key figure data;
• and
• in response to the total block being determined, generating, based on a run time query filter, the result sent with at least one instance corresponding to the blocked natural persons data removed from the result set and providing, to the server device, the generated result set without the at least one instance removed by the run time query filter.

A non-transitory computer-readable storage medium including program code which when executed by at least one processor causes operations comprising:

• receiving, at a data warehouse, a query from a server device including a model repository storing a database view, which in response to a client device request for a report, causes the query to be sent to and received by the data warehouse to enable blocking certain natural persons data, wherein the query obtains data for the report being generated for the server device, wherein the database view comprises a pre-defined database view stored at the model repository at the server device that is separate from the data warehouse, wherein the pre-defined database view is configured to send one or more pre-defined queries to the data warehouse to obtain the result set;
• processing, by the data warehouse, the query to identify data responsive to the query;
• evaluating the identified responsive data to determine whether there is corresponding metadata indicating a portion of the identified responsive data includes blocked natural persons data, wherein the metadata is stored at the data warehouse and is linked to the identified responsive data;
• when the blocked natural persons data is determined, evaluating the corresponding metadata to determine whether the block is a total block or a partial block, wherein the partial block allows key figure data, included in the identified responsive data, to be included in a result set, the key figure data providing an accurate numerical answer despite the partial block;
• in response to the partial block being determined, generating, based on the evaluated metadata, the result set including a predetermined value to mask the blocked natural persons data and to prevent the blocked natural persons data from being transmitted from the data warehouse to other devices including the server device, wherein the result set further includes key figure data associated with the blocked natural persons data;
• in response to the partial block being determined, providing, to the server device, the generated result set including the predetermined value to mask the blocked natural persons data and further including the key figure data;
• and
• in response to the total block being determined, generating, based on a run time query filter, the result sent with at least one instance corresponding to the blocked natural persons data removed from the result set and providing, to the server device, the generated result set without the at least one instance removed by the run time query filter.