0 Replies Latest reply: May 5, 2015 5:57 AM by Yasser BENAZZOUZ RSS

    Using INPUTFIELD and aggregating by fields

      Hi everyone,

       

      I am working on building a star table model. my fact table contains sessions informations. as dimension tables I have a table named store, another one with time and another one with products. I want to add using INPUTFIELD a field with a value for each Month and Store.
      This field will be used in my calculation later.

       

      Also, for a session, I don't have the store directly but I have only a serial number that is in my store table.

       

      Any idea of the script to use to do so?

       

      Many thanks !