Sounds like you are wanting a text string, like "First Week" instead of a week number, like 1, to appear. In the source table for your dimension, you will...

Not knowing what your tasks table looks like, I'm not sure if this is answering your question. But if I create a table like this:

CREATE TABLE tasks (

...

Nadrek (7/30/2010)

---

Katherine Fraser (7/30/2010)

---

....an application to audit any PHI access. That is, any time a stored procedure returns PHI to the application, I'll have to enter a log record...

I work at a company whose clients include pharmacies so several of our applications store PHI (protected health information) and must be "treated with special care" according to HIPAA.

I am...