_______________________________________________________________________________
<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