Hi,

a few weeks ago I had the same problem.

In my fact table, there was a column "CALMON" (01,02,03,04,.....)

And I asked me the same question, if I had to create a new table in my datahouse or just create the Dimension from the fact table.

After all I just create the DIM from the fact table, I think there are no problems with it.