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”





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s