Nectari Copilot for Data Models
Nectari Copilot in data models provides insights about the structure, content, and design of your data models. It can explain available dimensions and measures, describe how tables are linked, clarify calculation logic, and help you choose the right data model for your reporting needs.
Nectari Copilot is not available in the Data Model Designer. Open a view from the Data Models and Views tab in the navigation panel to ask questions about a data model. Nectari Copilot uses the metadata and design information from the selected data model to answer your questions.
Nectari Copilot cannot make changes to a data model's configuration.
What data models can do
Data models organize business data into a structured format that defines what information is available, how it is connected, and how it can be used for reporting. Some actions such as creating, editing, or linking tables can only be performed by an administrator.
- Design and configuration: structure, relationships, and properties.
- Dimensions and measures: descriptive and numeric fields available for analysis.
- Tables and joins: how tables are connected using key fields.
- Fields: properties, formats, visibility, and calculations.
- Data model parameters: input values used for filtering or adjustments.
- Stored procedures: predefined database operations.
- Info pages: supplementary data or context attached to the model.
Prompt ideas
Insights
Insights are observations and explanations about your data model's structure and contents.
- What dimensions and measures are available in this data model?Copy
- What is the calculation for margin % in SQL and JavaScript?Copy
- Based on the account in my current view, which ones should I use in a cash flow report?Copy
- Is there a Manufacturing dashboard available for Sage X3?Copy
- Are there any inventory reports available?Copy
- What dimensions are available in the invoice analysis data model?Copy
- Which data model should I use for margin analysis?Copy