Time prompt

building semantic layer
1

I have searched the forum and have not been able to find this issue.

I have 4 transaction tables like xyzdate,xyzweek,xyzmonth and xyzyear and i implemented the aggregate awareness on the objects. where xyz date table is aggregated at date level, xyzweek table is aggregated at week level,xyzmonth table is aggregated at month level and xyzyear table is aggregated at year level.

Now i would like to create a prompt/condition/object where user can select date or week or month or year.

Could you please let me know how to create the prompt for the same,

I am using BO XIR3 and SQL server 2005.

Thanks in advance,

versatilegene :india: (BOB member since 2008-03-18)