Creating and Editing Facts

After you have created a project, use the Fact Editor to:

• Create a New Fact

• Edit an Existing Fact

• Create fact expressions

Create a New Fact

1. Open the Workstation page.

2. Ensure that the Mosaic schema for your new fact is available for editing. You can unlock the schema in the Schema Editor by clicking the lock icon for the project.
3. In the Navigation pane, click Objects.
4. In the top right corner, click Create New Object.
5. In the Create New window, if you are connected to multiple projects, select the project from the drop-down list on the left.
6. Click Fact.
7. In the Definition tab, type a descriptive name for the new fact in Name.
8. In the All Tables pane, search for and select the source table for the fact.

   The source table is the table or logical view that contains the fact column on which you want to base a new fact.

9. From the Available columns pane, double-click the column or drag and drop it into the Expression pane.

   You can include multiple columns as well as use numeric constants and mathematical operators and functions to create a fact expression. For information on creating various types of fact expressions, see Mapping Physical Columns to Facts: Fact Expressions.

10. In the Expression pane, click Validate to ensure that the fact expression is correct.
11. Toggle on Auto Mapping to automatically select all available tables that contain columns used in the expression as source tables.
12. In the Expression pane, click Done. The expression is validated and displayed in the pane on the far left.
13. You can add another expression to the fact, using the steps above.
14. The data type is automatically filled in. If it is not correct, from the Data Type drop-down list, select the correct type.
15. Optionally add an Alias for display purposes. Type the Alias.
16. To display entry level attributes in the fact editor, click Show Entry Level.
17. You can create level extensions when creating and editing facts. See Create Fact Extensions for more information.

18. Click Save, Save As, Save and Close, or Save and New.

19. Optionally type a description in User Comments and click OK.

20. Navigate to the folder to save the fact in and click Save or Save As.
21. Close the Fact Editor.

    Update the schema

    Update the schema to load the new fact into the project.

22. In the Navigation pane, click Schemas, and then click the Reload Schema icon next to your project.

Edit an Existing Fact

1. Open the Workstation window.
2. Ensure that the Mosaic schema for your new fact is available for editing. You can unlock the schema in the Schema Editor by clicking the lock icon for the project.
3. In the Navigation pane, click Objects.
4. Search for the fact to edit. You can use the Filters panel to narrow the listed objects by clicking Type, selecting Fact, and clicking Apply.
5. Right-click the fact to:
   • Edit, add, and delete expressions
   • Change the data type
   • Add an alias
6. To display entry level attributes in the fact editor, click Show Entry Level.
7. You can create level extensions when creating and editing facts. See Create Fact Extensions for more information.

8. Click Save, Save As, Save and Close, or Save and New.

9. Optionally type a description in User Comments and click OK.

10. Close the Fact Editor.

    Update the schema

    Update the schema to load the new fact into the project.

11. In the Navigation pane, click Schemas, and then click the Reload Schema icon next to your project.

Create Fact Extensions

Create level extensions when creating and editing facts. Use level extensions to create custom hierarchies and levels in your datasets. For more information on level extensions, see Modifying the levels at which facts are reported: Level extensions.

1. While creating or editing a fact, click the Level Extension tab.

2. Type a Name and optional Description for the extension.

3. Expand the Type drop-down list and choose from the following extension type options:

   • Extend the fact entry level: Define a fact extension with attributes from a different hierarchy.

   • Lower the fact entry level: Define a fact degradation at a lower level within the same hierarchy. For more information on fact degradation, see Lowering the level of fact data: Fact degradations.

   • Disallow fact usage at the entry level: Define a fact extension that does not allow a fact to be reported at a specific attribute level.

4. If you choose Extend the fact entry level:

   1. Expand the Select the attribute(s) to extend to drop-down list and select the check box next to the attribute(s).

   2. Expand the Extend method drop-down list and choose from the following methods:

      • Use a specific relationship table: Select a relationship table and join method.

      • Use a related fact to connect tables: Select a fact and join method.

      • Use a cross product join: Forces facts to relate to the selected attribute. This method is not recommended by Strategy.

   3. Optionally select the check box next to Use custom allocation expression and enter an expression to use with the extension.

5. If you choose Lower the fact entry level:

   1. Expand the Select the attribute(s) to lower to drop-down list and select the check box next to the attribute(s).

   2. Expand the Select the attribute(s) to perform the join drop-down list and select the check box next to the attribute(s).

   3. To join against the attribute and its children, in the table, expand the drop-down list next to Join Against and choose Attribute and children.

   4. Optionally select the check box next to Use custom allocation expression and enter an expression to use with the extension.

6. If you choose Disallow fact usage at the entry level, expand the Select the attribute(s) to disallow and choose the attribute(s).

7. Click Save, Save As, Save and Close, or Save and New.

8. Optionally type a description in User Comments and click OK.