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 !