The invention discloses a user-defined multi-
dimensional analysis configuration method,
system and equipment based on a
constellation model and a medium, belongs to the technical field of
data analysis, and aims to solve the technical problem that basic data such as dimensions, indexes and data models in multi-
dimensional analysis are complicated to construct. According to the technical scheme, according to the method, the dimensionality, the index and the incidence relation between the
fact table and the dimensionality table configured by the model table are imported, the mapping between the dimensionality tables is automatically imported into the correlation table, the attribute and the model relation, the model maintenance cost is reduced, and the model maintenance time is shortened; ordered model construction is realized through dimensions, indexes, fact tables, dimension tables, data models and self-defined multi-dimensional query, multi-fact-table dimensions screen application configuration scenes of
reverse mapping of property of the fact tables, required indexes are flexibly selected from the fact tables through dragging operation, and according to a
cascade mode of the indexes and the dimensions, the application configuration scenes of
reverse mapping of property of the property of the fact tables are selected to be matched with the property of the property of the property of the property of the property of the property of the property of the property of the property of the property of the property of the property. And automatically screening out the generality dimension for display.