Example Processes

There are a variety of processes where the use case is standard across a model. Below is a list of these example processes and their purposes.

Processes

Utility Processes

• Utility.Copy Scenario.Simple - copy data from a Scenario to a Scenario within a Cube.
• Utility.Copy Scenario.Extended - copy data from a Scenario to a Scenario within a Cube. Has expanded logic compared to Simple.
• Utility.Export.Cube to Table - export data from a Cube to a Table.
• Utility.Export.Cube to CSV - export data from a Cube to a CSV.

Dimension Processes

• System.Dimension.Time - create a Time dimension. This process exists in every MODLR server by default.
• Dimension.Date - create a Date dimension.

Mapping Processes

• Mapping.Time to Time.Month to Year Annual - create a mapping from month to annual elements in the Time dimension.
• Mapping.Time to Time.Month to Prior Month - create a mapping from month to prior month in the Time dimension.
• Mapping.Time to Date.Month to Month - create a mapping from an n-level Time element to the month parent in the Date dimension.
• Mapping.Date to Time.Date to Month - create a mapping from an n-level Date element to an n-level Time element.
• Mapping.Date to Date.Date to Prior Year Month - create a mapping from a Date element to the prior year's month parent element in the Date dimension.
• Mapping.Date to Date.Date to Prior Year Date - create a mapping from a Date element to the prior year's date element in the Date dimension.

INFO

The Mapping.Date processes rely on the Date dimension being built as per Dimension.Date. They also rely on the Time dimension having been built per the standard System.Dimension.Time process.

Build Processes

• Build.Time and Date Environment - runs the System.Dimension.Time and Dimension.Date dimension builds together with all the mappings between them, so both dimensions stay aligned on the same periods.

Microsoft Business Central Processes

The processes here enable quicker establishment of modelling with Microsoft Business Central. These processes can be configured further based on your needs.

• Business Central.Export.Company - Used for exporting Business Central Company data. All other exports depend on this process. It does not truncate the table — it only adds new entries. The values this process inserts are used as identifiers between tables, so the primary key of this table cannot be changed freely, as doing so may require realigning other tables that reference it.
• Business Central.Export.Non Time Data - Used for exporting dimension data (dimension data in the data warehousing terminology, data that is not categorised by time). Commonly used for exporting data from Business Central Endpoints Account, Dimension and DimensionData.
• Business Central.Export.generalLedgerEntries - Used for for exporting generalLedgerEntries data that is categorised by time (transaction data in the data warehousing terminology).
• Business Central.Export.All - Runs all other Business Central processes required to maintain a model including:
  • Business Central.Export.Company
  • Business Central.Export.Non Time Data
  • Business Central.Export.generalLedgerEntries

INFO

All process listed here require the Business Central Integration Library. All processes are built around Microsoft Business Central v2.0.

Process Packages

Please refer to the documentation on Packages to utilise the process packages below.

• Time and Date Package Please click here to Download - contains the following processes:
  • Build.Time and Date Environment
  • Dimension.Date
  • Mapping.Time to Time.Month to Year Annual
  • Mapping.Time to Time.Month to Prior Month
  • Mapping.Date to Time.Date to Month
  • Mapping.Time to Date.Month to Month
  • Mapping.Date to Date.Date to Prior Year Month
  • Mapping.Date to Date.Date to Prior Year Date
• Business Central Integration Package. Please click here to Download - contains the following processes:
  • Business Central.Export.All
  • Business Central.Export.Company
  • Business Central.Export.Non Time Data
  • Business Central.Export.generalLedgerEntries

INFO

Processes listed as part of the Business Central Package require the Business Central Integration Library. This library require's configuration to the variables relating to your Business Central Environment