Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asqldeveloper
Starting Member
17 Posts |
 Posted - 2008-04-17 : 23:18:11
|
| I am developing reports against OLAP cube. I can select the date (calendar year) or Month Name from the date dimension to display as a parameter to the report. But, when I show that parameter drop down, how do I default the value for the current month or year? I tried the default values in the report parameters as a non-queried value writing an expression, but whatever I write there, it ignores when showing drop down. Any ideas? Please remember again that this is against Date dimension and also that Month and Year are two separate parameters (thus constituting two separate combo boxes and they are not multi-value). |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-04-18 : 13:50:57
|
| Not sure if this is what you require:report parameter (Data type should be set to integer) ~ Non-queried set the expression to =month(today)and below for year=year(today) |
 |
|
|
|
|
|
default date