Hey all,
Drilling through from cube to a report studio relational report and displaying date on the report header using paramdisplayvalue produces a display of 'between 2007-01-01 and 2007-12-31'
now, is it possible to change the category withion the cube so that something like 01-01-2007 is displayed for the month of jan and so on? If so, then the paramdisplayvalue will also display 'between 01-01-2007 and 12-31-2007.
Otherwise, it's virtually impossible to get the paramdisplayvalue to display MM/DD/YYYY
ANy ideas on how to change this category code?
Yes, it is. Every level in a cube has a set of properties, like short label, description, category code, et.