3 Replies Latest reply: Jun 20, 2014 9:57 AM by Bruno Souza RSS

    Referencing a column of a dimension in Set Analysis



      I have a general question about set analysis in a star schema.


      We all know that in start schema we have a fact table linked to many dimension via dimension key. Those dimensions and the fact table have another column.

      Suppose that you want to sum a measure according a condition on a column dimension knowing that the column on which you would like to apply the condition is not the key.


      For example,


      Customer Dimension :

      • customer key
      • customer name
      • customer town
      • customer country


      Date Dimension :

      • date
      • week
      • month
      • year


      Sale Fact

      • date
      • customer key
      • sale


      Which set analysis statement do you write to get the sum of sale of all customers of a specific country ?


      Thanks in advance.