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

    Referencing a column of a dimension in Set Analysis

      Hi,

       

      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.