A system for combining online transactional processing and online analytical processing in an in-memory database (180, 301, 401), comprising: the in-memory database (180, 301, 401) that is configured to execute a method comprising: - retrieving two or more tables (406a, 406b, 406c) from an online transaction processing system, wherein the retrieving the two or more tables (406a, 406b, 406c) comprises replicating the two or more tables (406a, 406b, 406c) in the in-memory database (180, 301, 401); - identifying related tables among the two or more tables, wherein the identifying related tables comprises determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables; - determining relationships between the related tables, wherein the determining relationships between the related tables comprises analyzing metadata of the two or more tables (406a, 406b, 406c); - determining a measure based on the relationships, wherein the determining of the measure based on the relationships comprises: -- identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and -- calculating the measure using the relationships of the related tables; and - outputting the measure, wherein the outputting of the measure comprises: -- associating the measure with a subset of columns and/or rows from the related tables; and -- outputting the measure with the subset of columns and/or rows. the in-memory database (180, 301, 401) that is configured to execute a method comprising: - retrieving two or more tables (406a, 406b, 406c) from an online transaction processing system, wherein the retrieving the two or more tables (406a, 406b, 406c) comprises replicating the two or more tables (406a, 406b, 406c) in the in-memory database (180, 301, 401); - identifying related tables among the two or more tables, wherein the identifying related tables comprises determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables; - determining relationships between the related tables, wherein the determining relationships between the related tables comprises analyzing metadata of the two or more tables (406a, 406b, 406c); - determining a measure based on the relationships, wherein the determining of the measure based on the relationships comprises: -- identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and -- calculating the measure using the relationships of the related tables; and - outputting the measure, wherein the outputting of the measure comprises: -- associating the measure with a subset of columns and/or rows from the related tables; and -- outputting the measure with the subset of columns and/or rows. - retrieving two or more tables (406a, 406b, 406c) from an online transaction processing system, wherein the retrieving the two or more tables (406a, 406b, 406c) comprises replicating the two or more tables (406a, 406b, 406c) in the in-memory database (180, 301, 401); - identifying related tables among the two or more tables, wherein the identifying related tables comprises determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables; - determining relationships between the related tables, wherein the determining relationships between the related tables comprises analyzing metadata of the two or more tables (406a, 406b, 406c); - determining a measure based on the relationships, wherein the determining of the measure based on the relationships comprises: -- identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and -- calculating the measure using the relationships of the related tables; and -- identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and -- calculating the measure using the relationships of the related tables; and - outputting the measure, wherein the outputting of the measure comprises: -- associating the measure with a subset of columns and/or rows from the related tables; and -- outputting the measure with the subset of columns and/or rows. -- associating the measure with a subset of columns and/or rows from the related tables; and -- outputting the measure with the subset of columns and/or rows.