Dash Prompt: display Current Week Start Date on top in choice list in obiee
Hi,
I am developing a report where we have a requirement to show Current Week Start date on top in the drop down list.
The week start date is Sunday '03/10/2013' and Week End date Saturday is '03/17/2013', it is directly coming from source and now when i do order by it is either going to the week of
2015 or 1950 based on desc or asec.
I want to display the current week start date as the default display using the dashboard prompt and i dont need week num, i need the date: I don't have rpd access to set the repository variable.
For example Week Start date as (03/18/2013 and Week End date as 03/23/2013), it should be dyanamic where based on current date it should default to that week start and end date. Please let me know your inputs.
Thanlks