Cubo

Este é o código em xml para a geração do cubo no StarSchema.

_______________________________________________________________________________

- <Schema name="tebd_clinica_etl">

- <Cube name="clinica" visible="true" cache="true" enabled="true">

  <Table name="clin_func_empr_exames" schema="tebd_clinica_etl" />

- <Dimension type="StandardDimension" visible="true" foreignKey="clin_func_empr_exam_fk_exames" highCardinality="false" name="Exames">

- <Hierarchy name="Exames" visible="true" hasAll="true" primaryKey="exam_codigo" primaryKeyTable="clin_exames">

  <Table name="clin_exames" schema="tebd_clinica_etl" />

  <Level name="TipoExame" visible="true" table="clin_exames" column="exam_nome" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  </Hierarchy>

  </Dimension>

- <Dimension type="StandardDimension" visible="true" foreignKey="clin_func_empr_exam_fk_medico" highCardinality="false" name="Medico">

- <Hierarchy name="Medico" visible="true" hasAll="true" primaryKey="medi_codigo" primaryKeyTable="clin_medico">

  <Table name="clin_medico" schema="tebd_clinica_etl" />

  <Level name="Especialidade" visible="true" table="clin_medico" column="medi_especialidade" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  <Level name="NomeMedico" visible="true" table="clin_medico" column="medi_nome" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  <Level name="CRM" visible="true" table="clin_medico" column="medi_crm" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  </Hierarchy>

  </Dimension>

- <Dimension type="StandardDimension" visible="true" foreignKey="clin_func_empr_exam_fk_tempo_exame" highCardinality="false" name="TempoExame">

- <Hierarchy name="TempoExame" visible="true" hasAll="true" primaryKey="temp_exam_codigo" primaryKeyTable="clin_tempo_exame">

  <Table name="clin_tempo_exame" schema="tebd_clinica_etl" />

  <Level name="AnoExame" visible="true" table="clin_tempo_exame" column="temp_exam_ano" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  <Level name="MesExame" visible="true" table="clin_tempo_exame" column="temp_exam_mes" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  <Level name="DiaExame" visible="true" table="clin_tempo_exame" column="temp_exam_dia" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  </Hierarchy>

  </Dimension>

  <Measure name="Qtd" column="clin_func_empr_exam_qtd" aggregator="sum" visible="true" />

  </Cube>

  </Schema>