Skip to main content
The data model is a YAML configuration file that defines the semantic layer between Polarion’s native work item types and Powersheet’s sheet views. It maps Polarion types, link roles, and custom fields into structured entity types and relationships that Powersheet uses for querying, displaying, and editing data. Without a data model, Powersheet cannot understand which work items to load or how they relate to each other.See the Data Model Reference for the complete property reference.
Data models are managed through the Polarion administration interface at Administration > Nextedy POWERSHEET > Data Models. You can create both global models (available to all projects) and project-specific models. Multiple models can coexist, and each sheet configuration references a specific model by name.
The three configuration layers are connected through navigation property names:
  • Data model defines entity types and relationships (with direct and back navigation names)
  • Sources define how to query and expand those relationships (using the navigation names)
  • Columns define how to display the resulting data (using dot-notation binding paths)
The cardinality of a relationship determines the expand pattern and column binding syntax. See the Sheet Configuration Reference for column binding details.
diagram