Date Prompt of Week

[nayitian]

Hi All,

I am having a RS report which runs against a fact table has 10 years history. The fact table is like:

WK_CODE     REGION      SALES_TOTAL
200301           A               10
...
200712           B               20

It should let user select certain week. How can I set a Calendar Date Prompt and week parameter and link them together?

Thank you.

[COGNOiSe administrator]

You probably have a lookup table somewhere in your DW that would allow you to tie dates to weeks. If not, use the date to week number function and add it to year. In pseudo code:

Code Select Expand


WeekcodeColumn = year(?parDate?) *100 + week_number(?parDate?)