The invention discloses a role playing dimension implementation method and
system, and relates to the technical field of
data processing. Comprising the steps that a meta-model of a dimension model related to a role playing dimension is created, the meta-model comprises five types of data tables, a role playing dimension name is selected from a role playing dimension name source according to requirements, when the role playing dimension name is different from a physical
dimension table name, it is considered that the dimension corresponding to the role playing dimension name is the role playing dimension, and the role playing dimension is selected from a physical
dimension table name; when the related dimension of one index is displayed, the role playing dimension name is used for replacing the physical dimension name to display the actual business meaning of the dimension, when the dimension is selected to summarize the indexes, the role playing dimension name is used for constructing a dynamic
SQL, and when the
composite index is analyzed, the actual business meaning of the dimension is displayed. When multiple indexes are analyzed in parallel, if the facts where the polyatomic indexes forming the composite indexes are located are all associated with the same physical dimension, the composite indexes are summarized through the physical dimension, and when the multiple indexes are analyzed in parallel, if the facts where all the indexes participating in analysis are located are all associated with the same physical dimension, the multiple indexes are summarized through the physical dimension; and the associated dimension
list is displayed by using the physical dimension name, so that
confusion caused by different role names is avoided.