Configure a relational cube
- Click New cube or select an existing cube.
- In relationship mapping, choose the fact table. It is the starting point for query aggregation.
- Add a measure and enter its name, display name, source column, data type, aggregation such as sum, and format string. Each cube needs at least one measure.
- Add dimensions and set the fact-table foreign key, dimension table, and primary key.
- In Semantic design, review the measure and dimension fields.
- Use the usage preview to review exposed fields, then open the Query lab for a real query.
Calculated members
In Calculations, add a calculated member with a name, dimension (usually the Measures dimension), and expression. An empty expression is a model quality error. Test complex expressions in the Query lab first.XMLA cubes
After importing an XMLA cube, remote bindings for the cube, measures, and dimensions come from the structure information. You can edit display names, visibility, variable defaults, and metric bindings in the XMLA workspace. If an object is missing, refresh the preview and confirm the remote model before changing anything.Before publishing
- The fact table and every relationship key exist.
- There is at least one measure, and each measure has a source column or a valid remote binding.
- Every dimension has at least one hierarchy and level.
- Every calculated member has an expression.
- Model quality has no blocking errors and the query probe succeeds in Run and cache.