source: intercambio/Dashboards/Cuadro 4.cda @ 7f3df6c

<?xml version="1.0" encoding="UTF-8"?>
<CDADescriptor>
   <DataSources>
      <Connection id="Rif" type="sql.jndi">
         <Jndi>smid</Jndi>
      </Connection>
      <Connection id="Nombre" type="sql.jndi">
         <Jndi>smid</Jndi>
      </Connection>
      <Connection id="RazonSocial" type="sql.jndi">
         <Jndi>smid</Jndi>
      </Connection>
      <Connection id="PrincipalesProductos" type="sql.jndi">
         <Jndi>smid</Jndi>
      </Connection>
      <Connection id="Info" type="sql.jndi">
         <Jndi>smid</Jndi>
      </Connection>
   </DataSources>
   <DataAccess access="public" cache="true" cacheDuration="3600" connection="Rif" id="Rif"
               type="sql">
      <Columns/>
      <Parameters/>
      <Query>SELECT
     "dimension_empresa"."rif"
FROM
     "dimension_empresa" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_empresa"."id" = "hechos_bienesproducidos_empresa"."id_empresa"
GROUP BY "dimension_empresa"."rif"
ORDER BY 1 asc</Query>
   </DataAccess>
   <DataAccess access="public" cache="true" cacheDuration="3600" connection="Nombre"
               id="Nombre"
               type="sql">
      <Columns/>
      <Parameters/>
      <Query>SELECT
     "dimension_empresa"."nombre"
FROM
     "dimension_empresa" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_empresa"."id" = "hechos_bienesproducidos_empresa"."id_empresa"
WHERE
     dimension_empresa.nombre NOT LIKE 'NO INDICA'
GROUP BY
     "dimension_empresa"."nombre"
ORDER BY
     1 ASC</Query>
   </DataAccess>
   <DataAccess access="public" cache="true" cacheDuration="3600" connection="RazonSocial"
               id="RazonSocial"
               type="sql">
      <Columns/>
      <Parameters/>
      <Query>SELECT
     "dimension_empresa"."razon_social"
FROM
     "dimension_empresa" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_empresa"."id" = "hechos_bienesproducidos_empresa"."id_empresa"
GROUP BY
     "dimension_empresa"."razon_social"
ORDER BY
     1 ASC</Query>
   </DataAccess>
   <DataAccess access="public" cache="true" cacheDuration="3600"
               connection="PrincipalesProductos"
               id="PrincipalesProductos"
               type="sql">
      <Columns/>
      <Parameters>
         <Parameter default="seleccion" name="seleccion" type="String"/>
      </Parameters>
      <Query>SELECT 
     "dimension_bien"."nombre" AS Name,
      "dimension_bien"."especificaciones_tecnicas" as Tecn,
     round(sum("hechos_bienesproducidos_empresa"."medida_monto_venta")::numeric,2) AS Total
FROM
     "dimension_bien" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_bien"."id" = "hechos_bienesproducidos_empresa"."id_bien"
     INNER JOIN "dimension_empresa" ON "hechos_bienesproducidos_empresa"."id_empresa" = "dimension_empresa"."id"
WHERE
     dimension_empresa.rif LIKE ${seleccion}
  OR dimension_empresa.nombre LIKE ${seleccion}
  OR dimension_empresa.razon_social LIKE ${seleccion}
GROUP BY
     Name,Tecn
ORDER BY
     Total DESC
LIMIT 10</Query>
   </DataAccess>
   <DataAccess access="public" cache="true" cacheDuration="3600" connection="Info" id="Info"
               type="sql">
      <Columns/>
      <Parameters>
         <Parameter default="seleccion" name="seleccion" type="String"/>
      </Parameters>
      <Query>SELECT
     "dimension_empresa"."rif" || ' - ' || "dimension_empresa"."razon_social"
FROM
     "dimension_empresa" 
WHERE
     dimension_empresa.rif LIKE ${seleccion}
  OR dimension_empresa.nombre LIKE ${seleccion}
  OR dimension_empresa.razon_social LIKE ${seleccion}</Query>
   </DataAccess>
</CDADescriptor>