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 4 Next »

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

To use the functionality a subscription from Canoe is required.

Setup Entities

Where to find it?

System Management - Canoe Entities

How to use it?

Setup entities in Canoe Intelligence.

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 support

Load and Map Canoe Entities with Apliqo

Management of Canoe Entities with Apliqo Investment Vehicles

  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

Fund Setup

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

Canoe Data Load

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”

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

Canoe Data Transfer

Source Data

  1. Choose a fund and quarter in the filter bar

  2. Source data from the Canoe Source data model is displayed, this is the raw data from Canoe

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

  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.

Mapping Table

Use custom mappings if custom transformations for funds are required

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

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

  • No labels