ReverseRelationship
The ReverseRelationship() function returns the primary entities linked to another entity according to a specified relationship type. For example, the function returns the portfolios to which a specified constituent is linked.
Related functions: Relationship, RelationshipData, Relationship.Period, Hierarchy, ReverseHierarchy
Syntax
ReverseRelationship (Entity, Relationships, IAAD, Headers, Source, ShowError)
| Entities |
An entity is any element in the Quintessence database that has data associated with it and is identified by a code, for example, an instrument, portfolio, country or manager.
|
| Relationships | The relationship type linking the entities, for example “constituent”. |
| IAAD | The information ‘as at’ date. |
| View |
This parameter takes the form ‘DataView(*):Headers’. To return specific columns, reference them by name, for example, “DataView(Entity,ValueDate)”. Using (*) returns all columns.
The value for Headers can be:
For example, “DataView(*):column” or “DataView():none”
|
| Source | The source of the data. Examples of sources: MarketDataProvider2, PortfolioAdministrator1, MarketDataProvider1 etc. |
| ShowError | If ShowError is set to TRUE, a standard Excel error message will be displayed if the function fails. |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Example 1. Return the portfolios to which a constituent is linked
Example 2. Return the portfolios with a presence in a particular country
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example 1. Return the portfolios to which a constituent is linked
Return the portfolios linked to constituent XDU, as at 1 January 2015.
| Function |
| =ReverseRelationship(“XDU”,”Constituent”,”1 Jan 2015″,”Dataview(*):column”) |
| Output | ||||
| Parent | Relationship | Source | Date | Child |
| XDU | Constituent | StockExchange1 | 2015/01/01 | 5010 |
| XDU | Constituent | StockExchange1 | 2015/01/01 | 5040 |
| XDU | Constituent | StockExchange1 | 2015/01/01 | 5070 |
Example 2. Return the portfolios with a presence in a particular country
Return the funds which have a presence in Singapore, as at 31 May 2015, showing all columns, with headers.
| Function |
| =ReverseRelationship(“Singapore”,”Presence”,”31 May 2015″,”Dataview(*):column”) |
| Output | ||||
| Parent | Relationship | Source | Date | Child |
| Singapore | Presence | MarketDataProvider2 | 2015/05/31 | 5020 |
| Singapore | Presence | MarketDataProvider2 | 2015/05/31 | 5030 |
| Singapore | Presence | MarketDataProvider2 | 2015/05/31 | 5090 |