Add currency dimension question
When adding a dimension such as currency to a SQL server table, do we have to reload data or can we set the default to USD?
When adding the dimension the Fac table is cleared.
clint pauyon replied
You can set the default as 'USD' so that every time you input a new entry will automatically fill-up but then again if your table have already data then previous data will not be USD only the present data will get the USD value, you will manually update the previous value.