🧊 Semantic Model
Semantic Model: Responsible for organizing technically oriented data into business-oriented data for business users to query and analyze.
The semantic model here is also a workspace where, based on the connected data sources, technical personnel can perform data querying and modeling work.
Currently, a semantic model can only connect to one data source.
- Manage Semantic Models
- Semantic Modeling Workspace
- Query Lab
- Dimension Designer
- Multidimensional Dataset Designer
Semantic Model Types
The data logic implementation of the semantic model supports two syntax types: SQL and MDX. The semantic model itself does not distinguish syntax. The difference between SQL and MDX syntax lies in the underlying implementation of the data logic of the semantic model. When semantic modeling, the only thing to note is that different syntax implementations may lead to some differences in data query results. In general, the SQL version's implementation will be less than the MDX version. The SQL version is used for relatively simple data modeling requirements and situations where users are more familiar with SQL syntax.
The MDX version is easier to implement complex data processing requirements, which also imposes higher demands on users. Users need to understand MDX syntax and common functions, but this is not mandatory.
If the model does not need to develop complex calculation formulas and other functions, there is no need to master MDX syntax.