Galaxies
The Galaxies feature in AnalyticsCreator is used to group related stars (star schemas) into logical collections for organizing multidimensional or tabular models. Galaxies provide structure for larger analytical solutions by clustering stars into shared business domains.
Function
Each galaxy acts as a container for star schemas. This allows developers to manage and visualize related stars more effectively, particularly in large-scale data warehouse projects. Galaxies also influence model generation behavior and naming conventions.
Access
Galaxies are managed under the Data Mart > Galaxies module. The interface provides both a list view of existing galaxies and an editor for creating or updating galaxy definitions.
Properties – List View
| ID | Property | Description |
|---|---|---|
| 1 | Name | The display name of the galaxy |
| 2 | Galaxy | Galaxy group to which the star schema belongs |
| 3 | Schema | Database schema in which the galaxy resides |
| 4 | Order in diagram | Defines the position of the galaxy in the diagram for layout purposes |
| 5 | Description | Optional text describing the galaxy’s business context or contents |
Properties – Edit View
| ID | Property | Description |
|---|---|---|
| 1 | Star name | Name of the star schema being configured within the galaxy |
| 2 | Galaxy | Dropdown selector to assign the star to a galaxy group |
| 3 | Schema | Database schema for the star definition |
| 4 | Order in diagram | Defines visual positioning of the star schema in the galaxy diagram |
| 5 | Description | Optional user-provided description for documentation purposes |
| 6 | Multidimensional | Tab for configuring logic specific to multidimensional models (OLAP) |
| 7 | Tabular | Tab for configuring logic specific to tabular models (e.g., Power BI) |
| 8 | MDX | Text area for entering custom MDX expressions for multidimensional models |
| 9 | Cancel | Discards changes and exits the galaxy editor |
| 10 | Save | Commits the changes and saves the galaxy configuration to project metadata |
Screen Overview
The image below shows the Galaxies List screen with numbered columns for identification.
The image below shows the Galaxies Edit screen for configuring the properties of a galaxy and its stars.
Behavior
- Each galaxy can contain one or more star schemas
- Star schemas can be configured for either multidimensional or tabular modeling
- MDX logic is specific to OLAP-based deployments and ignored for tabular models
- Galaxies are purely organizational and do not affect physical database schema
Notes
- Galaxies help manage large models by grouping related stars into business domains
- They influence visual layout and metadata structure in generated models
- Galaxies are project-specific and version-controlled with the metadata
