--- url: /technical/example-processes.md --- # 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](process-utility-copy-cube-scenario-to-scenario-simple) - copy data from a **Scenario** to a **Scenario** within a **Cube**. * [Utility.Copy Scenario.Extended](process-utility-copy-cube-scenario-to-scenario-extended) - copy data from a **Scenario** to a **Scenario** within a **Cube**. Has expanded logic compared to Simple. * [Utility.Export.Cube to Table](process-utility-export-cube-table) - export data from a **Cube** to a **Table**. * [Utility.Export.Cube to CSV](process-utility-export-cube-csv) - export data from a **Cube** to a **CSV**. ### Dimension Processes * [System.Dimension.Time](process-system-dimension-time) - create a **Time** dimension. This process exists in every MODLR server by default. * [Dimension.Date](process-dimension-date) - create a **Date** dimension. ### Mapping Processes * [Mapping.Time to Time.Month to Year Annual](process-mapping-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](process-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](process-mapping-time-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](process-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](process-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](process-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](process-dimension-date). They also rely on the **Time** dimension having been built per the standard [System.Dimension.Time](process-system-dimension-time) process. ::: ### Build Processes * [Build.Time and Date Environment](process-build-time-date-environment) - runs the [System.Dimension.Time](process-system-dimension-time) and [Dimension.Date](process-dimension-date) dimension builds together with all the [mappings](example-processes.html#mapping-processes) 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](https://www.modlr.co/au/integrations/microsoft-business-central). These processes can be configured further based on your needs. * [Business Central.Export.Company](process-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](process-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](process-business-central-export-general-ledger-entries) - Used for for exporting `generalLedgerEntries` data that is categorised by time (transaction data in the data warehousing terminology). * [Business Central.Export.All](process-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](process-libraries-business-central-integration-library). All processes are built around Microsoft Business Central v2.0. ::: ### Salesforce Processes * [Salesforce Example](process-salesforce-example) - a rough example of a process connecting to Salesforce, making a basic request using the tokens from a [Standard Integration](/technical/integrations.html#standard-integrations). ::: info This process requires a [Standard Integration](/technical/integrations.html#standard-integrations) to have been set up with Salesforce - see [Creating an Integration](/technical/creating-an-integration.html). ::: ### MYOB Processes * [MYOB AccountRight Example](process-myob-accountright-example) - an example of a process connecting to MYOB AccountRight, making a request using the tokens from a [Standard Integration](/technical/integrations.html#standard-integrations). ::: info This process requires a [Standard Integration](/technical/integrations.html#standard-integrations) to have been set up with MYOB - see [Creating an Integration](/technical/creating-an-integration.html). ::: ### Xero Processes * [Xero Example](process-xero-example) - an example of a process connecting to Xero, listing the available organisations (tenants) for a connection and fetching each organisation's details. ::: info This process requires a [Standard Integration](/technical/integrations.html#standard-integrations) to have been set up with Xero - see [Creating an Integration](/technical/creating-an-integration.html). ::: ### QuickBooks Processes * [QuickBooks Example](process-quickbooks-example) - an example of a process connecting to QuickBooks, making a basic request using the tokens from a [Standard Integration](/technical/integrations.html#standard-integrations). ::: info This process requires a [Standard Integration](/technical/integrations.html#standard-integrations) to have been set up with QuickBooks - see [Creating an Integration](/technical/creating-an-integration.html). ::: ### Procore Processes * [Procore Example](process-procore-example) - an example of a process connecting to Procore, making a basic request using the tokens from a [Standard Integration](/technical/integrations.html#standard-integrations). ::: info This process requires a [Standard Integration](/technical/integrations.html#standard-integrations) to have been set up with Procore - see [Creating an Integration](/technical/creating-an-integration.html). ::: ### Chargebee Processes * [Chargebee Example](process-chargebee-example) - an example of a process connecting to Chargebee, authenticating with an API key and paging through results. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### Deel Processes * [Deel Example](process-deel-example) - an example of a process connecting to Deel, authenticating with an API token and client ID. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### Zambion Processes * [Zambion Example](process-zambion-example) - an example of a process connecting to Zambion, including a small library that handles OAuth 2.0 client credentials authentication. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### ProcurePro Processes * [ProcurePro Example](process-procurepro-example) - an example of a process connecting to ProcurePro, including a small library that handles the access-token based authentication. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### PAYAPPS Processes * [PAYAPPS Example](process-payapps-example) - an example of a process connecting to PAYAPPS, including a small library that handles the OAuth password grant and token refresh. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### NetSuite Processes * [NetSuite Process Example](netsuite-examples#process-example) - an example of a process connecting to NetSuite's SuiteTalk REST API, including a small library that handles OAuth 1.0 request signing, querying the `account` table via SuiteQL with pagination. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). * NetSuite can also be connected as a [Datasource](/technical/datasources.html) using its own JDBC driver - see the [NetSuite Datasource Example](netsuite-examples#datasource-example). ### HammerTech Processes * [HammerTech Example](process-hammertech-example) - an example of a process connecting to HammerTech, including a small library that handles email/password/tenant authentication and paging through results. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### PropertyMe Processes * [PropertyMe Example](process-propertyme-example) - an example of a process connecting to PropertyMe, including a small library that handles its OAuth 2.0 refresh token flow. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### Eagle CRM Processes * [Eagle CRM Example](process-eaglecrm-example) - an example of a process connecting to Eagle CRM's GraphQL API, including a small library that handles token authentication and cursor-based pagination. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### Fixer Processes * [Fixer Example](process-fixer-example) - an example of a process connecting to Fixer to pull historical foreign exchange rates. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### Sage MicrOpay Processes * [Sage MicrOpay Example](process-sage-micropay-example) - a simple example of a process connecting to Sage MicrOpay (Micropay Cloud API), including a small library that handles Basic Auth plus an API key header. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### ChatGPT Processes * [ChatGPT Example](process-chatgpt-example) - a simple example of a process sending a prompt to ChatGPT and reading back the response. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ### Claude Processes * [Claude Example](process-claude-example) - a simple example of a process sending a prompt to Claude via Anthropic's Messages API and reading back the response. This is an [Advanced Integration](/technical/integrations.html#advanced-integrations). ## Process Packages Please refer to the documentation on [Packages](packages.html#packages) to utilise the process packages below. * Time and Date Package Please click here to [Download](https://modlr-excel-downloads.s3.ap-southeast-2.amazonaws.com/docs/MODLR+Time+and+Date+Package.package) - 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](process-package-business-central-integration-package). Please click here to [Download](https://modlr-excel-downloads.s3.ap-southeast-2.amazonaws.com/docs/Business+Central+Integration+Library.package) - 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](process-libraries-business-central-integration-library). This library require's configuration to the variables relating to your Business Central Environment :::