 cerebus
|
 |
| Joined: 23 Apr 2007 |
| Total Posts: 5 |
| |
|
Calendar dimension used in ReportModel
Posted: 04 Oct 2007 08:57 PM |
If I have a Calendar dimension in SSAS 2005, and have a report model built on top of this, if I have a field called FiscalMonth (with its Type property set to FiscalMonths), is there any way to get the greater than filter in ReportBuilder to function as a date check rather than an alphabetical check?
What I'm seeing is if I filter greater than Jan 2007 for Fiscal Month, I get Jun 2006 in my results, but not April 2007.
Cheers. |
|
|
 |
|
|
Re: Calendar dimension used in ReportModel
Posted: 17 Oct 2007 12:55 PM |
The field needs to be a datetime for that to work.
You could do a view in the report model to add the field as a datetime.
|
Thanks
Phill
Colt 45 - the original point and click interface ;)
http://philcart.blogspot.com/ |
|
|
|