Tutorial 01 – Ellie

Instructions how to get the model to the point where it can be read by D# Engine.

Watch the video here.

Task	Description
Open the Ellie Metadata reference	Open the “Ellie metadata cheat sheet” and keep it available.
Start Ellie	Log in to your Ellie account.
Create new Model for Person and Gender	Click the + sign in the Models section of Ellie to create a new model. Name the model PersMaster person register (RM) and click Create.
Create class Person	Add a new entity to the model using the Glossary search function: write the name of the entity to be added (Person) and click Create Person. The Person entity will then appear in the list below. Drag the Person entity to the model / diagram canvas. Right-click on the Person entity and set its Entity type to Master.
Add Person attributes	Double-click the Person entity. Activate the Attributes tab. Click Edit. On the line labeled +New attribute, write Person Id and press tab (or click to the right of the field) so that the value registers and the entire edit row becomes visible. In the Data Type field, write hetu. Similarly, add the following attributes / data types Last name / lastname First names / firstnames Nickname / firstname Date of birth / birthdate Set Date of birth’s Rate of change to Never by adding the line Rate of change=Never; to the Notes field of the attribute. The parameter value can also be copied from the Ellie Metadata reference, from the Property Metadata Values section.
Set Person metadata	Click the Metadata tab. Copy the entity template metadata for Master entities into the metadata text field. Set Implement to true. Set Key to Person Id. In the Ellie title bar, click on the model name to return to the diagram.
Create class Gender	Write Gender in the Glossary search box, then click Create Gender. Drag the newly created Gender entity to the model. Right-click on the Gender entity and set its Entity type to Reference.
Add Gender attributes	Double-click the Gender entity. Click the Attributes tab. Click Edit. Add the following attributes / data types Code / code Name / name
Set Gender metadata	Click the Metadata tab Copy the entity template metadata for Reference entities into the metadata text field. Set Implement to true. Set Key to Code. In the Ellie title bar, click on the model name to return to the diagram.
Create relation between Person and Gender	Move the mouse near the middle of the edge of the Gender entity, and when a circle is shown, press the left mouse button, drag towards the middle of the edge of the Person entity and release when a circle appears. Adjust the relation type of the Gender side of the relation so that it signifies a mandatory singular relation (a single short line crossing the association line). Do this by right-clicking the end of the relation.
Set the Person.Gender association end’s Rate of change to Never.	This feature is not yet supported by Ellie.
Create a report for exporting the model	Go to the Ellie home page by clicking either the company name or the Ellie logo in the Ellie toolbar. Click View all reports. Click Create report. Name the report DemoDW export. Under the Which models should be part of this report? prompt, write PersMaster and select the newly created model from the list that appears. Click Create report.
Export the model.	Click Export. From the popup menu, select Export entities. Repeat for Export attributes and Export relations. Each export results in a ellie-report-DemoDW-Export*.csv file containing the partial model export. Copy or move these to your working directory. After this, D# Engine will read them when opened the next time. Remove any previous copies of the export files from your working directory.