<Schema name="statistiche">
  <Cube name="statistiche" capti visible="true" cache="true" enabled="true">
    <Table name="fact_table" schema="bi_test">
    </Table>
    <Dimension type="StandardDimension" visible="true" foreignKey="fk_tipo_ordine" highCardinality="false" name="TipoOrdine" capti Ordine">
      <Hierarchy name="Tipo Ordine" visible="true" hasAll="true" allMemberName="TuttigliOrdini" allMemberCapti gli Ordini" allLevelName="Tutti gli Ordini" primaryKey="fk_tipo_ordine" capti gli Ordini">
        <Table name="dim_tipo_ordine" schema="bi_test">
        </Table>
        <Level name="TipoOrdine" visible="true" column="tipo_ordine" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" capti Ordine">
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" foreignKey="fk_tempo" highCardinality="false" name="Tempo">
      <Hierarchy name="Tempo" visible="true" hasAll="true" allMemberName="TuttigliAnni" allMemberCapti gli Anni" allLevelName="Tutti gli Anni" primaryKey="id_tempo" capti gli Anni">
        <Table name="dim_tempo" schema="bi_test">
        </Table>
        <Level name="Anno" visible="true" column="anno" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" capti>
        </Level>
        <Level name="Mese" visible="true" column="desc_mese" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" capti>
        </Level>
        <Level name="Giorno" visible="true" column="giorno_mese" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" capti>
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" foreignKey="fk_codice_biblioteca_erogatrice" highCardinality="false" name="BibliotecaErogatrice" capti Erogatrice">
      <Hierarchy name="BibliotecaErogatrice" visible="true" hasAll="true" allMemberName="TutteleErogatrici" allMemberCapti le Erogatrici" allLevelName="Tutte le Erogatrici" primaryKey="fk_codice_biblioteca" capti le Erogatrici">
        <Table name="dim_biblioteca" schema="bi_test">
        </Table>
        <Level name="BibliotecaErogatrice" visible="true" column="codice_biblioteca" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" capti Erogatrice">
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" foreignKey="fk_codice_biblioteca_richiedente" highCardinality="false" name="BibliotecaRichiedente" capti Richiedente">
      <Hierarchy name="Biblioteca Richiedente" visible="true" hasAll="true" allMemberName="TutteleRichiedenti" allMemberCapti le Richiedenti" allLevelName="Tutte le Richiedenti" primaryKey="fk_codice_biblioteca" capti le Richiedenti">
        <Table name="dim_biblioteca" schema="bi_test">
        </Table>
        <Level name="BibliotecaRichiedente" visible="true" column="codice_biblioteca" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" capti Richiedente">
        </Level>
      </Hierarchy>
    </Dimension>
 <Dimension type="StandardDimension" visible="true" foreignKey="fk_attributi" highCardinality="false" name="Attributi" capti>
      <Hierarchy name="Articolo" visible="false" hasAll="true" allMemberName="Articoli" allMemberCapti allLevelName="Articoli" primaryKey="fk_attributi" capti>
        <Table name="dim_attribute" schema="bi_test">
        </Table>
        <Level name="Articolo" visible="true" column="articolo" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" capti>
        </Level>
   </Hierarchy>
   <Hierarchy name="Rivista" visible="false" hasAll="true" allMemberName="Riviste" allMemberCapti allLevelName="Riviste" primaryKey="fk_attributi" capti>
        <Table name="dim_attribute" schema="bi_test">
        </Table>
        <Level name="Rivista" visible="true" column="titolorivista" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" capti>
        </Level>
   </Hierarchy>
    </Dimension>
 <Measure name="Ordini" column="ordini" datatype="Integer" aggregator="sum" visible="true">
    </Measure>
 <Measure name="Evase" column="conteggio_evase" datatype="Integer" aggregator="sum" capti Evase" visible="true">
    </Measure>
    <Measure name="Inevase" column="conteggio_inevase" datatype="Integer" aggregator="sum" capti Inevase" visible="true">
    </Measure>
    <CalculatedMember name="TotaleEvaseInevase" capti di Entrambe" formula="[Measures].[Evase]+[Measures].[Inevase]" dimensi visible="true">
    </CalculatedMember>
  </Cube>
</Schema>