Changing category code for date

[Arsenal]

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?

[COGNOiSe administrator]

Yes, it is. Every level in a cube has a set of properties, like short label, description, category code, et.