This invention discloses a method and
system for implementing role-playing dimensions, relating to the field of
data processing technology. It includes: creating a meta-model of dimension models related to role-playing dimensions, the meta-model comprising five types of data tables; selecting role-playing dimension names from their sources according to requirements; when a role-playing dimension name differs from a physical
dimension table name, the dimension corresponding to the role-playing dimension name is considered a role-playing dimension; when displaying the related dimensions of an indicator, using the role-playing dimension name to replace the physical dimension name to demonstrate the actual business meaning of the dimension; when summarizing the indicator using selected dimensions, constructing dynamic
SQL using the role-playing dimension name; when analyzing composite indicators, if the facts of the multi-atomic indicators constituting the
composite indicator are all associated with the same physical dimension, then the
composite indicator is summarized using that physical dimension; when performing parallel analysis of multiple indicators, if the facts of each indicator involved in the analysis are all associated with the same physical dimension, then the multiple indicators are summarized using the physical dimension; and displaying the
list of related dimensions using the physical dimension name to avoid
confusion caused by different role names.