Advertisement
Guest User

Untitled

a guest
May 26th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.24 KB | None | 0 0
  1. <Dimension type="TimeDimension" name="Date Facture">
  2. <Hierarchy hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
  3. <Table name="dim_date" alias="dim_date_facture">
  4. </Table>
  5. <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
  6. </Level>
  7. <Level name="Quarter" column="quarter_number" nameColumn="quarter_name" type="Integer" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" caption="Trimestre">
  8. </Level>
  9. <Level name="Month" column="month_number" nameColumn="month_name" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" caption="Mois">
  10. </Level>
  11. <Level name="Day" column="day_in_month" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
  12. </Level>
  13. </Hierarchy>
  14. <Hierarchy name="Weekly" hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
  15. <Table name="dim_date" alias="dim_date_facture">
  16. </Table>
  17. <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
  18. </Level>
  19. <Level name="Week" column="week_in_year" type="Integer" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never" caption="Semaine">
  20. </Level>
  21. <Level name="Day" column="day_in_week" nameColumn="day_name" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
  22. </Level>
  23. </Hierarchy>
  24. </Dimension>
  25. <Dimension type="TimeDimension" name="Date Envoi">
  26. <Hierarchy hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
  27. <Table name="dim_date" alias="dim_date_envoi">
  28. </Table>
  29. <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
  30. </Level>
  31. <Level name="Quarter" column="quarter_number" nameColumn="quarter_name" type="Integer" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" caption="Trimestre">
  32. </Level>
  33. <Level name="Month" column="month_number" nameColumn="month_name" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" caption="Mois">
  34. </Level>
  35. <Level name="Day" column="day_in_month" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
  36. </Level>
  37. </Hierarchy>
  38. <Hierarchy name="Weekly" hasAll="true" allMemberName="All" allMemberCaption="Toutes dates" primaryKey="date_key">
  39. <Table name="dim_date" alias="dim_date_envoi">
  40. </Table>
  41. <Level name="Year" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Annee">
  42. </Level>
  43. <Level name="Week" column="week_in_year" type="Integer" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never" caption="Semaine">
  44. </Level>
  45. <Level name="Day" column="day_in_week" nameColumn="day_name" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Jour">
  46. </Level>
  47. </Hierarchy>
  48. </Dimension>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement