Skip to main content

Relationships

Data on the platform is linked: a product record points to its hub and exchange, a smart curve is built from other curves and a script, and a type has subtypes and records. The Relationships report draws those links for the selected item and answers questions like:

  • Which curves, scripts and calendars does this smart curve depend on?
  • Which records does this master data record point to?
  • Which records and subtypes use this type?
  • Which curves use this expiry calendar?

At Northgate Energy, Tom Clarke opens Relationships on the smart curve NGE_SPREADS:CLEAN_SPARK_DE to see everything a change to the German power or TTF curves would affect.

Relationships of the master data record NGE_PRODUCT

Opening the report​

Relationships is an item insight: select an item, then open Relationships from its insights. It is registered as #INSIGHT_ITEM_RELATIONSHIP in the category *Item Insights*.

The portal passes the item's service (SERVICE), source (SOURCE) and id (ID). The chart is drawn as soon as the report opens. There are no filters.

Reading the chart​

The selected item is in the middle, with its id as the chart title and its type underneath.

PositionWhat it shows
LeftWhat the item belongs to or is based on (its parents)
MiddleThe selected item
RightWhat the item points to, or what uses it (its children)

Each box shows an id and, underneath, a name or label where there is one. The colour tells you what kind of entity a box is:

ColourEntity
GreyData: curves and timeseries
TanMaster data records
Pale greyEvent lists
YellowTypes, scripts and calendars

Click any box to redraw the chart around that entity, and keep clicking to follow a chain of dependencies. Hover over a box to see its service. The chart grows taller as more boxes are added and scrolls inside its own frame.

note

Long ids are cut off at the edge of a box. Hover over the box or click it to see the full id as the chart title.

What is shown for each kind of item​

Selected itemLeft (parents)Right (children)
Master data recordIts type (#Object if it has none)Every property that is a reference to another entity, labelled with the reference name
Smart curveIts master data recordThe base curve (labelled BASE), every curve in its properties (labelled with the property name), the script and expression, the expiry calendar, the holiday calendar, and any smart curves built on it
Event curveIts master data recordThe event list, the expiry calendar and the holiday calendar, and any smart curves built on it
Other curve or timeseriesIts master data recordAny smart curves built on it
TypeThe type it extends (#Object if none)Its subtypes, then the records of that type, or the event lists of that type for an event type
Expiry calendarThe event curves, smart curves and curves that use itIts holiday calendar
Event listIts event type and the event curves and timeseries built from it

Other kinds of item are not supported yet: the chart title says, for example, script - not supported yet.

A smart curve​

Relationships of the smart curve NGE_SPREADS

The clean spark spread is built from German power base (BASE), TTF gas (GAS) and EU carbon (CARBON) with the script NGE_SPREAD_FUNCTIONS, on the expiry calendar #ICE.ENDEX.TTF and the holiday calendar #EEX. The peak spread at the bottom is another smart curve that uses it as its base.

A type​

Relationships of the type NGE_Product

NGE_Product extends NGE_Commodity, has two subtypes, and is used by five product records.

Troubleshooting​

ProblemWhat to do
The chart is empty or shows only the itemThe item has no links the report knows about, or you have no read access to the linked items.
The title says not supported yetThe report does not draw relationships for that service.