/
getAttributeLineageForJustOneCell.platform_call
134 lines (134 loc) · 12.4 KB
/
getAttributeLineageForJustOneCell.platform_call
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?xml version="1.0" encoding="UTF-8"?>
<platform_call:PlatformCallModule xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:column_transformation_logic="http://www.eclipse.org/efbt/column_transformation_logic" xmlns:functions="http://www.eclipse.org/efbt/functions" xmlns:platform_call="http://www.eclipse.org/efbt/platform_call" xmlns:row_transformation_logic="http://www.eclipse.org/efbt/row_transformation_logic" license="Copyright (c) 2020 Bird Software Solutions Ltd&#xA; All rights reserved. This file and the accompanying materials are made available under the terms of the Eclipse Public License v2.0 which accompanies this distribution, and is available at http://www.eclipse.org/legal/epl-v20.html&#xA;&#xA;SPDX-License-Identifier: EPL-2.0 &#xA;&#xA; Contributors:&#xA; Neil Mackenzie - initial API and implementation&#xD;">
<platformCalls xsi:type="platform_call:GetAttributeLineageForOneReportCell" name="getAttributeLineageForJustOneCell" reportCell="../extra/reportcell_definitions.trl_report_cell_views#totalJPMktValue" transformationContext="../extra/example_release.transformation#example_release">
<resultingModel name="ALM_JPY_MktValue">
<rowTransformations usedInSubsets="true">
<columnFunctionGroup>
<columnFunctions xsi:type="column_transformation_logic:AggregateColumnFunction" columnID="aggregateLoans:ECB2_MRKT_VL" cube="../extra/efbt_cubes.cubes#aggregateLoans" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_MRKT_VL">
<aggregateFunction name="sum" functionSpec="../extra/commonFunctions.functions#SUM">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#loans:ECB2_MRKT_VL"/>
</aggregateFunction>
</columnFunctions>
<columnFunctions xsi:type="column_transformation_logic:AggregateColumnFunction" columnID="aggregateLoans:ECB2_ENTITY_LEI" cube="../extra/efbt_cubes.cubes#aggregateLoans" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_ENTITY_LEI">
<aggregateFunction functionSpec="#First">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#loans:ECB2_ENTITY_LEI"/>
</aggregateFunction>
</columnFunctions>
</columnFunctionGroup>
<rowCreationApproachForCube cube="../extra/efbt_cubes.cubes#aggregateLoans" name="aggregateLoans">
<rowCreationApproach xsi:type="row_transformation_logic:GroupByRowCreationApproach" groupByColumns="../bird_import/variables.efbt_data_definition#ECB2_ENTITY_LEI" groupByCubeColumns="#loans:ECB2_ENTITY_LEI">
<dependantCubeColumns cubeColumn="#loans:ECB2_ENTITY_LEI"/>
</rowCreationApproach>
</rowCreationApproachForCube>
</rowTransformations>
<rowTransformations usedInSubsets="true">
<columnFunctionGroup>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="aggregateLoansAndCounterparties:ECB2_MRKT_VL" cube="../extra/efbt_cubes.cubes#aggregateLoansAndCounterparties" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_MRKT_VL">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#aggregateLoans:ECB2_MRKT_VL"/>
</basicFunction>
</columnFunctions>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="aggregateLoansAndCounterparties:ECB2_ENTITY_LEI" cube="../extra/efbt_cubes.cubes#aggregateLoansAndCounterparties" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_ENTITY_LEI">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#counterparty:ECB2_ENTITY_LEI"/>
</basicFunction>
</columnFunctions>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="aggregateLoansAndCounterparties:CNTRY" cube="../extra/efbt_cubes.cubes#aggregateLoansAndCounterparties" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#CNTRY">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#counterparty:CNTRY"/>
</basicFunction>
</columnFunctions>
</columnFunctionGroup>
<rowCreationApproachForCube cube="../extra/efbt_cubes.cubes#aggregateLoansAndCounterparties" name="aggregateLoansAndCounterparties">
<rowCreationApproach xsi:type="row_transformation_logic:RowJoinFunction">
<dependantCubeColumns cubeColumn="#aggregateLoans:ECB2_ENTITY_LEI"/>
<dependantCubeColumns cubeColumn="#counterparty:ECB2_ENTITY_LEI"/>
<joinFunction name="=" functionSpec="../extra/commonFunctions.functions#=">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#aggregateLoans:ECB2_ENTITY_LEI"/>
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#counterparty:ECB2_ENTITY_LEI"/>
</joinFunction>
</rowCreationApproach>
</rowCreationApproachForCube>
</rowTransformations>
<rowTransformations usedInSubsets="true">
<columnFunctionGroup>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="loansCounterpartiesAndRatings:ECB2_MRKT_VL" cube="../extra/efbt_cubes.cubes#loansCounterpartiesAndRatings" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_MRKT_VL">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#aggregateLoansAndCounterparties:ECB2_MRKT_VL"/>
</basicFunction>
</columnFunctions>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="loansCounterpartiesAndRatings:CNTRY" cube="../extra/efbt_cubes.cubes#loansCounterpartiesAndRatings" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#CNTRY">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#aggregateLoansAndCounterparties:CNTRY"/>
</basicFunction>
</columnFunctions>
</columnFunctionGroup>
<rowCreationApproachForCube cube="../extra/efbt_cubes.cubes#loansCounterpartiesAndRatings" name="loansCounterpartiesAndRatings">
<rowCreationApproach xsi:type="row_transformation_logic:RowJoinFunction">
<dependantCubeColumns cubeColumn="#aggregateLoansAndCounterparties:ECB2_ENTITY_LEI"/>
<dependantCubeColumns cubeColumn="#rating:ECB2_ENTITY_LEI"/>
<joinFunction name="==" functionSpec="../extra/commonFunctions.functions#=">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#aggregateLoansAndCounterparties:ECB2_ENTITY_LEI"/>
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#rating:ECB2_ENTITY_LEI"/>
</joinFunction>
</rowCreationApproach>
</rowCreationApproachForCube>
</rowTransformations>
<rowTransformations usedInSubsets="true">
<columnFunctionGroup>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="enrichedExposures:ECB2_MRKT_VL" cube="../extra/efbt_cubes.cubes#enrichedExposures" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_MRKT_VL">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#loansCounterpartiesAndRatings:ECB2_MRKT_VL"/>
</basicFunction>
</columnFunctions>
<columnFunctions xsi:type="column_transformation_logic:StandardBasicColumnFunction" columnID="enrichedExposures:CNTRY" cube="../extra/efbt_cubes.cubes#enrichedExposures" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#CNTRY">
<basicFunction functionSpec="#CopyColumn">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#loansCounterpartiesAndRatings:CNTRY"/>
</basicFunction>
</columnFunctions>
</columnFunctionGroup>
<rowCreationApproachForCube cube="../extra/efbt_cubes.cubes#enrichedExposures" name="enrichedExposures">
<rowCreationApproach xsi:type="row_transformation_logic:OneToOneRowCreationApproach"/>
</rowCreationApproachForCube>
</rowTransformations>
<rowTransformations usedInSubsets="true">
<columnFunctionGroup>
<columnFunctions xsi:type="column_transformation_logic:AggregateColumnFunction" columnID="totalJPMktValue:ECB2_MRKT_VL" cube="../extra/efbt_cubes.cubes#totalJPMktValue" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_MRKT_VL">
<aggregateFunction functionSpec="#SUM">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#enrichedExposures:ECB2_MRKT_VL"/>
</aggregateFunction>
</columnFunctions>
<columnFunctions xsi:type="column_transformation_logic:AggregateColumnFunction" columnID="totalJPMktValue:CNTRY" cube="../extra/efbt_cubes.cubes#totalJPMktValue" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#CNTRY">
<aggregateFunction functionSpec="#First">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#enrichedExposures:CNTRY"/>
</aggregateFunction>
</columnFunctions>
</columnFunctionGroup>
<rowCreationApproachForCube cube="../extra/efbt_cubes.cubes#totalJPMktValue" name="totalJPMktValue_view">
<rowCreationApproach xsi:type="row_transformation_logic:FilterAndGroupToOneRowCreationApproach" groupByVariables="../bird_import/variables.efbt_data_definition#CNTRY">
<dependantCubeColumns cubeColumn="#enrichedExposures:CNTRY"/>
<filterFunction functionSpec="#isEqualTo">
<parameters xsi:type="functions:ResolvedCubeColumnParameter" cubeColumn="#enrichedExposures:CNTRY"/>
<parameters xsi:type="functions:MemberParameter" param="../bird_import/members.efbt_data_definition#EBA_GA_EBA_JP"/>
</filterFunction>
</rowCreationApproach>
</rowCreationApproachForCube>
</rowTransformations>
<baseSchemas cube="../extra/efbt_cubes.cubes#counterparty" usedInSubsets="true">
<columns columnID="counterparty:ECB2_ENTITY_LEI" cube="../extra/efbt_cubes.cubes#counterparty" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_ENTITY_LEI"/>
<columns columnID="counterparty:CNTRY" cube="../extra/efbt_cubes.cubes#counterparty" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#CNTRY"/>
</baseSchemas>
<baseSchemas cube="../extra/efbt_cubes.cubes#rating" usedInSubsets="true">
<columns columnID="rating:ECB2_ENTITY_LEI" cube="../extra/efbt_cubes.cubes#rating" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_ENTITY_LEI"/>
</baseSchemas>
<baseSchemas cube="../extra/efbt_cubes.cubes#loans" usedInSubsets="true">
<columns columnID="loans:ECB2_MRKT_VL" cube="../extra/efbt_cubes.cubes#loans" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_MRKT_VL"/>
<columns columnID="loans:ECB2_ENTITY_LEI" cube="../extra/efbt_cubes.cubes#loans" usedInSubsets="true" variable="../bird_import/variables.efbt_data_definition#ECB2_ENTITY_LEI"/>
</baseSchemas>
<specialFunctionSpecs xsi:type="functions:BasicFunctionSpec" functionalName="funcs.CopyColumn" name="CopyColumn" sqlName="ID"/>
<specialFunctionSpecs xsi:type="functions:AggregateFunctionSpec" functionalName="funcs.First" name="First" sqlName="First"/>
<specialFunctionSpecs xsi:type="functions:AggregateFunctionSpec" functionalName="funcs.SUM" name="SUM" sqlName="SUM"/>
<specialFunctionSpecs xsi:type="functions:BasicFunctionSpec" functionalName="==" name="isEqualTo" sqlName="=" isInfix="true"/>
</resultingModel>
</platformCalls>
</platform_call:PlatformCallModule>