Commits

tbrugz committed 2e8e9e3 Draft

mondrian: add medida 'cand_bens_count' ao cubo 'tse_candidatos'

Comments (0)

Files changed (2)

 );
 
 create table tse_candidatos_bens ( -- type=TABLE
-	seq_candidato bigint(19),
+	seq_candidato bigint(19) not null,
 	ano_eleicao smallint,
 	cd_tipo_bem smallint,
 	ds_bem varchar(200),

modelo/tse-mondrianschema.xml

             </Hierarchy>
         </Dimension>
         <Measure visible="true" aggregator="sum" column="VL_BEM" name="vl_bem"/>
+        <Measure visible="true" aggregator="count" column="SEQ_CANDIDATO" name="cand_bens_count"/>
     </Cube>
     <Cube name="tse_detalhe_secao">
         <Table schema="PUBLIC" name="TSE_DETALHE_SECAO"/>