Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 5 Next »

Apliqo can integrate with Canoe Intelligence (Canoe) API’s.

To use the functionality a subscription from Canoe is required.

System Integration

The integration between Canoe and Apliqo is setup and manged by Apliqo.

If any issues arise, the client can contact apliqoC3.helpdesk@cubewise.com for assistance.

Configuration in Canoe

Maintain the Entries (Benefical Owners and Legal entities) and the documents in Canoe UI.

https://client.canoesoftware.com/

Logins are provided by Canoe Intelligence.

Please consult the Canoe Intelligence documentation for further suppor

image-20240110-093727.png

Account Configuration

image-20240110-093807.png

Entities configuration

image-20240110-093915.png

Investment configuration

image-20240110-094032.png

image-20240110-094103.png

Investment - Entity Allocation

image-20240110-094152.png

Setup in Apliqo

Setup Entities

This screen allows you to compare the available Entities in Canoe with the Investment Vehicles in Apliqo LPPM and ensure all Investment Vehicles are mapped to an Entity.

Where to find it?

System Management - Canoe Entities

How to use it?

  1. Load Canoe Entities by pressing the load button
    Apliqo will sync all the entities from the organisations on Canoe.

  2. Maintain the Investment Vehicle structures in the “Apliqo Investment Vehicles” Widget
    Add/Move/Delete the Vehicles (e.g. Legal Entities or Beneficial Owners) in the structure

  3. Copy/Paste the Canoe Entity API_id from the “Canoe Entities” Widget to the CanoeAPI_id in the “Apliqo Investment Vehicles” Widget in the correct Investment Vehicle

image-20240109-160813.png

Setup Funds

This screen allows you to compare the available Funds in Canoe with the Funds in Apliqo LPPM and ensure all Funds are mapped to the correct unique ID code used in Canoe.

Where to find it?

System Management - Canoe Funds

How to use it?

Setup funds in Canoe Intelligence

Maintain the Funds and the map documents in Canoe UI.

https://client.canoesoftware.com/
Logins are provided by Canoe Intelligence.

Please consult the Canoe Intelligence documentation for support

Load and Map Canoe Funds with Apliqo

Management of Canoe Funds with Funds in Apliqo

  1. Load Canoe funds by pressing the load button
    Apliqo will sync all the funds from the organisation on Canoe as a list in the “Canoe funds” widget

  2. Copy/Paste the Canoe Fund Id from the “Canoe Funds” Widget to the CanoeAPI_id in the “Apliqo LP PM Funds” Widget

  3. Pick from drill down “Canoe Data Type” the reporting type of the fund

    1. YTD - Year to date

    2. QTD - Quarter to date

    3. ITD - Inception to date

image-20240109-161156.png

Account Statement Data Load

Displays all documents regardless of category and type for the selected fund and date range. Value fields to display can be filtered by selecting the value type (BAL, QTD, YTD, ITD).

Where to find it?

System Management - Canoe Data Load

How to use it?

Check the data already loaded

Apliqo loads nightly the data for the current quarter from Canoe

  1. Choose a fund and data filter from Filter Bar

  2. Choose Value Type in filter bar to see the raw data

  3. Check documents and data in Canoe Documents Widgets

  4. Select the type with filter

  5. jump to the Canoe document in the hyperlink “link to document”

image-20240109-161347.png

Load new documents from Canoe

If new document data on Canoe has been loaded the upload can be enforced

  1. Press “Load documents from Canoe” in the filter bar

  2. Configure the “Fetch Canoe Documents” Wizard

    1. Fund: optional to choose fund

    2. Start date: optional

    3. End date: optional

Account Statement Check

This screen is designed as a check so that for a selected quarter you can immediately identify and funds which have no available call notices and see a count of documents by fund by investment vehicle where documents are available. Clicking on the 'Fund' field in the table on the left will filter the table on the right which lists all documents and provides a link directly to each document in the Canoe Inteligent Document Center.

image-20240109-161649.png

Capital Call Notice Check

This screen is designed as a check so that for a selected quarter you can immediately identify and funds which have no available distribution notices and see a count of documents by fund by investment vehicle where documents are available. Clicking on the 'Fund' field in the table on the left will filter the table on the right which lists all documents and provides a link directly to each document in the Canoe Inteligent Document Center.

image-20240109-161843.png

Current vs. Automated Load - Account Statements

This screen displays the variance for each fund with Canoe Load enabled between the data processed from Canoe versus the current state of the Apliqo LPPM Fund Input cube for the selected quarter. By clicking on the hyperlink in the 'Fund' field you will be navigated directly to the mapping screen for the selected fund where you could troubleshoot errors and correct mapping. In any cell in the table itself if you right-click and select 'drill' you can navigate directly to the mapping in the Canoe Intelligent Document Center.

image-20240109-161941.png

Current vs. Automated Load - Capital Notices

This screen displays the variance for each fund with Canoe Load enabled between the data processed from Canoe versus the current state of the Apliqo LPPM Fund Input cube for the selected quarter. By clicking on the hyperlink in the 'Fund' field you will be navigated directly to the mapping screen for the selected fund where you could troubleshoot errors and correct mapping. In any cell in the table itself if you right-click and select 'drill' you can navigate directly to the mapping in the Canoe Intelligent Document Center.

image-20240109-162050.png

Data Transformation

Once you have established connectivity between Canoe and Apliqo you can begin transmitting
your documents.

Workflow from loading Canoe account statements, processing the data and loading to the Apliqo LP PM data model. You can use the screen

  1. to perform ad-hoc loads from Canoe,

  2. adjust custom mapping at the fund level,

  3. copy mapping and load data to the Fund Input cube in Aplipq LP PM.

  1. Optional: Press “Process Account Statements” button to process the newly loaded documents

  2. Check if the data is properly transformed
    NB: e.g. the management fees Entity are displayed as negative numbers, the load to the LP PM model will transform them to positive numbers.

image-20240109-162849.png

Standard Transformation

All loaded data, nightly batch are automatically transformed according to the defined mappings per fund.

Shows the transformed data by the standard transformation, this is the basis for the custom mappings . Either from standard mappings or custom mappings.

  • Contributions

    • Capital

    • Periode

    • Current notice

  • Distributions

  • NAV

You can toggle this view between the Fund Input sums or the native Canoe fields. You can also toggle between value types and drill down on different combinations of columns. For most funds 'standard mapping' works in most cases. However some funds report with different definitions and in extra detail which can result in double-counting of components of some Fund Input measures and an incorrect sum. In such cases use the table bwlow to create a custom mapping.

image-20240108-104824.pngimage-20240108-105211.png

Apliqo LP PM Input (Canoe Load view)

Displays the data in the LP PM model.

Reload the data into LP PM model to test the adjusted mapping

  1. Delete the entire data in the table by selecting them and press delete

  2. Press “Load to LP PM” button

  3. complete wizard

    1. Mode

      1. load preview: will only display in the table, the stored data remains unchanged

    2. Check in Data Management - Fund Data Input - Infidem Input
      Difference NAV to Value Bridge in historic quarter - the difference should lower then 1%

Manual data entry

If data is required that is not reported by the GP in the account statement, e.g. un-/realized Carry, the input can be done in the Fund Data Input UI. see /wiki/spaces/AISD/pages/2436530565

image-20240108-104857.png

Mapping Table

Use custom mappings if custom transformations for funds are required

Use this table to create custom mappings to individually select the native Canoe fields to include in each Fund Input data entry field. You can enter directly in the table for all fields except the 'Canoe Staging Transform Measure' where the 'Edit' button is used to select the components from the Canoe documents to sum into the Fund Input field.

image-20240108-104842.png

Create custom mapping

The data load from the Canoe Source Data Model to the LP PM Model

  1. click on “Edit” icon in Measure row. The Measures are the LP PM input Measures, in other words the target measures.

  2. Complete the “Create custom mapping” wizard

    1. Choose single fund or add multiple funds

    2. Select from drilldown “Mapped Canoe Components” the measure from the Canoe Source data model

    3. Press “create mapping” button

  3. Optional: Change “Canoe Data Type 1” to YTD, QTD, ITD

  4. Optional: flip operator from positiv to negative in “Operation 1”

  5. Optional: change weighting to adjust the '000 format

  6. Load to “LP PM” button to start the load and transformation from the Canoe Source data model to the LP PM model

image-20240108-105052.png

Measure

Canoe Data Type Default

Manual Input

Map Check 1

Canoe Data Type 1

Operation 1

Canoe Staging Transform Measure 1

Edit

Map Check 2

Canoe Data Type 2

Operation 2

Canoe Staging Transform Measure 2

Edit

image-20240108-104952.png

Source Data

Displays the available account statements and mapped value fields for the selected fund and quarter. Clicking 'reload documents' will perform a manual live refresh from Canoe for the selected fund and quarter only.

image-20240108-104812.png

  • No labels