Find missing fields in your OLAP Excel reports

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”