terça-feira, 14 de agosto de 2012

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>

Nenhum comentário:

Postar um comentário