Changeset eb4808c in intercambio

Timestamp:

Dec 5, 2013, 2:52:49 PM (10 years ago)

Author:

carismendi <carismendi@…>

Branches:

master

Children:

d13507c

Parents:

65431d3

Message:

actualizacion de cuadro de mando 2

Location:

Dashboards

Files:

• Cuadro 2.cda (modified) (1 diff)
• Cuadro 2.cdfde (modified) (2 diffs)

Dashboards/Cuadro 2.cda

@@ -113 +113 @@
      )
 ORDER BY Monto DESC)   
-ORDER BY 2 DESC</Query>
+ORDER BY 2 ASC</Query>
    </DataAccess>
    <DataAccess access="public" cache="true" cacheDuration="3600" connection="sqlAnyo"

Dashboards/Cuadro 2.cdfde

@@ -2208 +2208 @@
      {
       "name": "clickAction",
-      "value": "function cod(a) {\n // alert(\"msg\"+a.series);\n  Dashboards.fireChange('cod',a.series);\n}",
+      "value": "function cod(a) {\n // alert(\"msg\"+a.series);\n  alert(\"Seleccione año\");\n  Dashboards.fireChange('cod',a.series);\n}",
       "type": "JavaScript"
      }
@@ -3869 +3869 @@
      {
       "name": "query",
-      "value": "(SELECT\n     \"dimension_empresa\".\"razon_social\" AS Empresa,\n     sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") AS Monto\nFROM\n     \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n     INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n     INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n     dimension_codigoarancelario.codigo LIKE ${cod}\n AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY\n    Empresa\nORDER BY Monto DESC\nLIMIT 10)\nUNION\n(SELECT \n     'Otras Empresas' as Empresa,\n     sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") as Monto  \nFROM\n     \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n     INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n     INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n     dimension_codigoarancelario.codigo LIKE ${cod} AND CAST(dimension_tiempo.anyo AS text) = ${anyo} AND dimension_empresa.id not in (\n   SELECT\n     \"hechos_bienesproducidos_empresa\".\"id_empresa\" \nFROM\n     \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n     INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n     INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n     dimension_codigoarancelario.codigo LIKE ${cod}\n     AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY 1   \n     )\nORDER BY Monto DESC)   \nORDER BY 2 DESC       \n",
+      "value": "(SELECT\n     \"dimension_empresa\".\"razon_social\" AS Empresa,\n     sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") AS Monto\nFROM\n     \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n     INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n     INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n     dimension_codigoarancelario.codigo LIKE ${cod}\n AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY\n    Empresa\nORDER BY Monto DESC\nLIMIT 10)\nUNION\n(SELECT \n     'Otras Empresas' as Empresa,\n     sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") as Monto  \nFROM\n     \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n     INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n     INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n     dimension_codigoarancelario.codigo LIKE ${cod} AND CAST(dimension_tiempo.anyo AS text) = ${anyo} AND dimension_empresa.id not in (\n   SELECT\n     \"hechos_bienesproducidos_empresa\".\"id_empresa\" \nFROM\n     \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n     INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n     INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n     dimension_codigoarancelario.codigo LIKE ${cod}\n     AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY 1   \n     )\nORDER BY Monto DESC)   \nORDER BY 2 ASC       \n",
       "type": "SqlQuery"
      },