Alright, so you are using Project Server and are familiar with fields such as “Status Date” and “% work complete”. Now you want to create an Excel Services report using one of the standard OLAP cubes. The report should provide the user with a list of all projects in one column, “Status Date” in the second column and “% work complete” in the third column.
Here comes the tricky part – YOU CAN´T FIND ALL THE FIELDS YOU NEED!
Before you panic, and maybe start develop your own OLAP cubes, you should try going to “OLAP Tools->Property Fields”
Choose the fields you need to display in your report
The fields will now be showed next to your original dimension e.g. “Project List”
3 comments