Data Analysis Calculations

[EPMLearner]

Hi All,

I have created a timesheet view (actual work) in Data Analysis on Project
Server 2007. To give you an image - I have the resource list and project
list on the left and at the top (columns) I have Month and Days and actual
work is the data critereon. We are trying to see actual work entered each
day by project.

The problem I am experiencing is the way the 'Days' column reads ...Day 1,
Day 2, Day 3. Does anyone know an MDX expression to change that into Mon,
Tues Weds or some other date format to make is easier to read?

 

[Dale Howard [MVP]]

EPMLearner --

I don't believe there is any way to change the formatting of the Time
dimension. Instead, you might want to try using the Fiscal Time dimension
instead, which gives you a little more information at the Day level. Hope
this helps.