== Descripción ==
Lista los valores calculados de los subconjuntos de dimensiones definidos dentro de un módulo para corroborar el correcto dimensionamiento de un módulo
== Composición ==
*[[TABLA:modulosdet]]
*[[TABLA:moduloscab]]

== Estructura ==
<pre>
</pre>
== SQL ==
<pre>
CREATE VIEW vischeckmod AS
SELECT 
    modulosdet.ModuloID,
    'W' AS Dimension,
    modulosdet.SubSetAncho AS SubSet,
    Sum(modulosdet.AnchoPredef) AS DimCalculo,
    moduloscab.ModuloVW as DimPredef
FROM
    fzggestion.modulosdet AS modulosdet,
    fzggestion.moduloscab AS moduloscab
WHERE
    modulosdet.ModuloID = moduloscab.ModuloID AND
    modulosdet.SubSetAncho IS NOT NULL
GROUP BY
    modulosdet.SubSetAncho
UNION
SELECT 
    modulosdet.ModuloID,
    'H' AS Dimension,
    modulosdet.SubSetAlto AS SubSet,
    Sum(modulosdet.AltoPredef) AS DimCalculo,
    moduloscab.ModuloVH as DimPredef
FROM
    fzggestion.modulosdet AS modulosdet,
    fzggestion.moduloscab AS moduloscab
WHERE
    modulosdet.ModuloID = moduloscab.ModuloID AND
    modulosdet.SubSetAlto IS NOT NULL
GROUP BY
    modulosdet.SubSetAlto
</pre>
== Bitácora ==
*20121127
**Alta Vista.
== Uso ==
== URL ==