MS SQL Data Warehousing - Re: Date Dimensions

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Date Dimensions

Brian Madden

2005-04-06, 8:01 pm

How is your date dimension designed? The standard is -

PK Year Month Week Date

Then when you set the dimension up in AS, set it as a star, and set the levels,
year down to date. That way you can drill down to the day.

-- Brian
[color=darkred]
> Hi,
> Problem is more general than a date dimension. It is a general
> failure. I
> was misinterpreting the error message.
> I shall do some more investigation.
> "Bob" <bob@nowhere.com> wrote in message
> news:%23Ja74vgKFHA.3392@TK2MSFTNGP10.phx.gbl...
> year.
>
> want
>

Sponsored Links