Hi,
I'm trying to build a Fiscal Year date dimension in Transformer 7.0. The dimension will be based on a field in my DB called CANCEL_DATE.
I've been trying to use the date wizard. I select Lunar Period; a 4-5-4 pattern; week begins on Sunday; etc.
When the dimension builds, the dates are always week beginning dates based on Sunday (I guess that's b/c Sunday was the day I chose for week beginning).
I don't want to display week beginning. I want to display week ending date. I have a field on my DB called WEEK_END_DATE. I tried to associate the LABEL for the WEEK level to this field, but no success.
Anybody successfully do this? I've had a case open with Cognos since last Friday and they don't return my emails or voice mails. :-(
Thanks!
I'm trying to build a Fiscal Year date dimension in Transformer 7.0. The dimension will be based on a field in my DB called CANCEL_DATE.
I've been trying to use the date wizard. I select Lunar Period; a 4-5-4 pattern; week begins on Sunday; etc.
When the dimension builds, the dates are always week beginning dates based on Sunday (I guess that's b/c Sunday was the day I chose for week beginning).
I don't want to display week beginning. I want to display week ending date. I have a field on my DB called WEEK_END_DATE. I tried to associate the LABEL for the WEEK level to this field, but no success.
Anybody successfully do this? I've had a case open with Cognos since last Friday and they don't return my emails or voice mails. :-(
Thanks!