Stars
The Stars feature in AnalyticsCreator defines multidimensional or tabular star schemas used to structure data marts. Stars group related fact and dimension tables under a galaxy and define the MDX logic needed for OLAP or tabular models.
Function
Stars organize tables into a unified structure for reporting and analysis. They define schema, display order, and allow MDX scripting per star. Stars are typically grouped within galaxies and are used during semantic model generation.
Access
Stars are managed under the Data mart > Stars module. The Stars list displays existing definitions and allows editing or adding new ones.
Properties
| ID | Property | Description |
|---|---|---|
| 1 | Star Name | Unique name for the star schema |
| 2 | Galaxy | Name of the galaxy this star belongs to |
| 3 | Schema | SQL schema where the star and related tables reside |
| 4 | Order in Diagram | Controls the layout position of the star in diagrams |
| 5 | Description | Optional text to describe the purpose of the star schema |
| 6 | Multidimensional | Tab for defining MDX logic for multidimensional models |
| 7 | Tabular | Tab for defining expressions for tabular models |
| 8 | MDX | Text area to input MDX expression or logic per tab |
| 9 | Cancel | Closes the editor without saving changes |
| 10 | Save | Persists changes and updates the star definition |
| 11 | Delete | Removes the selected star from the project |
| 12 | New | Creates a new star schema entry |
Screen Overview
The image below shows the List Stars interface with labeled columns for identifying each star's key metadata.
The image below shows the Star Edit screen used to define or update star schema properties and MDX logic.
Behavior
- Stars are grouped under galaxies and organize related tables in data marts
- Each star can include MDX logic for multidimensional or tabular models
- Stars influence semantic layer generation and OLAP behavior
- Changes to stars require regeneration to be reflected in output artifacts
Notes
- Star schemas are only logical groupings; they don’t alter physical table structure
- MDX is optional and mostly used for OLAP model definitions
- Multiple stars can exist in one galaxy and support multiple reporting models
