1 | <?xml version="1.0" encoding="UTF-8"?> |
---|
2 | <CDADescriptor> |
---|
3 | <DataSources> |
---|
4 | <Connection id="Codigos" type="sql.jndi"> |
---|
5 | <Jndi>smid</Jndi> |
---|
6 | </Connection> |
---|
7 | <Connection id="Distribucion" type="sql.jndi"> |
---|
8 | <Jndi>smid</Jndi> |
---|
9 | </Connection> |
---|
10 | <Connection id="Anyos" type="sql.jndi"> |
---|
11 | <Jndi>smid</Jndi> |
---|
12 | </Connection> |
---|
13 | <Connection id="tPaises" type="sql.jndi"> |
---|
14 | <Jndi>smid</Jndi> |
---|
15 | </Connection> |
---|
16 | </DataSources> |
---|
17 | <DataAccess access="public" cache="true" cacheDuration="3600" connection="Codigos" |
---|
18 | id="Codigos" |
---|
19 | type="sql"> |
---|
20 | <Columns/> |
---|
21 | <Parameters/> |
---|
22 | <Query>SELECT DISTINCT |
---|
23 | "dimension_codigoarancelario"."codigo", |
---|
24 | "dimension_codigoarancelario"."codigo"||' - '||"dimension_codigoarancelario"."descripcion_ref" |
---|
25 | FROM |
---|
26 | "dimension_codigoarancelario" |
---|
27 | WHERE |
---|
28 | character_length(dimension_codigoarancelario.codigo) >=10 |
---|
29 | ORDER BY |
---|
30 | "dimension_codigoarancelario"."codigo" ASC</Query> |
---|
31 | </DataAccess> |
---|
32 | <DataAccess access="public" cache="true" cacheDuration="3600" connection="Distribucion" |
---|
33 | id="Distribucion" |
---|
34 | type="sql"> |
---|
35 | <Columns/> |
---|
36 | <Parameters> |
---|
37 | <Parameter default="cod" name="cod" type="String"/> |
---|
38 | </Parameters> |
---|
39 | <Query>SELECT |
---|
40 | "dimension_tiempo"."anyo" AS anyo, |
---|
41 | sum("hechos_insumos_empresa"."medida_cantidad_nacional") AS nacional, |
---|
42 | sum("hechos_insumos_empresa"."medida_cantidad_importada") AS importado |
---|
43 | FROM |
---|
44 | "dimension_tiempo" INNER JOIN "hechos_insumos_empresa" ON "dimension_tiempo"."id" = "hechos_insumos_empresa"."id_tiempo" |
---|
45 | INNER JOIN "dimension_codigoarancelario" ON "hechos_insumos_empresa"."id_codigo_arancelario" = "dimension_codigoarancelario"."id" |
---|
46 | WHERE |
---|
47 | dimension_codigoarancelario.codigo LIKE ${cod} |
---|
48 | GROUP BY |
---|
49 | anyo</Query> |
---|
50 | </DataAccess> |
---|
51 | <DataAccess access="public" cache="true" cacheDuration="3600" connection="Anyos" id="Anyos" |
---|
52 | type="sql"> |
---|
53 | <Columns/> |
---|
54 | <Parameters> |
---|
55 | <Parameter default="cod" name="cod" type="String"/> |
---|
56 | </Parameters> |
---|
57 | <Query>SELECT |
---|
58 | "dimension_tiempo"."anyo" AS anyo |
---|
59 | FROM |
---|
60 | "dimension_tiempo" INNER JOIN "hechos_insumos_empresa" ON "dimension_tiempo"."id" = "hechos_insumos_empresa"."id_tiempo" |
---|
61 | INNER JOIN "dimension_codigoarancelario" ON "hechos_insumos_empresa"."id_codigo_arancelario" = "dimension_codigoarancelario"."id" |
---|
62 | WHERE |
---|
63 | dimension_codigoarancelario.codigo LIKE ${cod} |
---|
64 | GROUP BY |
---|
65 | anyo</Query> |
---|
66 | </DataAccess> |
---|
67 | <DataAccess access="public" cache="true" cacheDuration="3600" connection="tPaises" |
---|
68 | id="tPaises" |
---|
69 | type="sql"> |
---|
70 | <Columns/> |
---|
71 | <Parameters> |
---|
72 | <Parameter default="cod" name="cod" type="String"/> |
---|
73 | <Parameter default="anyo" name="anyo" type="String"/> |
---|
74 | </Parameters> |
---|
75 | <Query>SELECT DISTINCT |
---|
76 | "dimension_proveedor"."pais_origen" as Paises |
---|
77 | FROM |
---|
78 | "dimension_proveedor" INNER JOIN "hechos_proveedores_codigoarancelario" ON "dimension_proveedor"."id" = "hechos_proveedores_codigoarancelario"."id_proveedor" |
---|
79 | WHERE |
---|
80 | hechos_proveedores_codigoarancelario.id_insumo IN ( SELECT "hechos_insumos_empresa"."id_insumo" FROM "dimension_codigoarancelario" INNER JOIN "hechos_insumos_empresa" ON "dimension_codigoarancelario"."id" = "hechos_insumos_empresa"."id_codigo_arancelario" INNER JOIN "dimension_tiempo" ON "hechos_insumos_empresa"."id_tiempo" = "dimension_tiempo"."id" WHERE dimension_codigoarancelario.codigo LIKE ${cod} AND CAST(dimension_tiempo.anyo AS text) = ${anyo} ) |
---|
81 | AND dimension_proveedor.insumo_nacional = 'E'</Query> |
---|
82 | </DataAccess> |
---|
83 | </CDADescriptor> |
---|