Add currency dimension question

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

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.

regards,

Clint