Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Dimension type="TimeDimension" name="Date Facture">
- <Hierarchy hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
- <Table name="dim_date" alias="dim_date_facture">
- </Table>
- <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
- </Level>
- <Level name="Quarter" column="quarter_number" nameColumn="quarter_name" type="Integer" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" caption="Trimestre">
- </Level>
- <Level name="Month" column="month_number" nameColumn="month_name" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" caption="Mois">
- </Level>
- <Level name="Day" column="day_in_month" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
- </Level>
- </Hierarchy>
- <Hierarchy name="Weekly" hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
- <Table name="dim_date" alias="dim_date_facture">
- </Table>
- <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
- </Level>
- <Level name="Week" column="week_in_year" type="Integer" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never" caption="Semaine">
- </Level>
- <Level name="Day" column="day_in_week" nameColumn="day_name" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
- </Level>
- </Hierarchy>
- </Dimension>
- <Dimension type="TimeDimension" name="Date Envoi">
- <Hierarchy hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
- <Table name="dim_date" alias="dim_date_envoi">
- </Table>
- <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
- </Level>
- <Level name="Quarter" column="quarter_number" nameColumn="quarter_name" type="Integer" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" caption="Trimestre">
- </Level>
- <Level name="Month" column="month_number" nameColumn="month_name" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" caption="Mois">
- </Level>
- <Level name="Day" column="day_in_month" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
- </Level>
- </Hierarchy>
- <Hierarchy name="Weekly" hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
- <Table name="dim_date" alias="dim_date_envoi">
- </Table>
- <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
- </Level>
- <Level name="Week" column="week_in_year" type="Integer" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never" caption="Semaine">
- </Level>
- <Level name="Day" column="day_in_week" nameColumn="day_name" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
- </Level>
- </Hierarchy>
- </Dimension>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement