Dear Forum,

is it possible to export task dates (start, finish) from the project plan via Report > Export > Visual Reports to a local olap cube/ Excel? I unsuccessfully tried several existing export templates, also modifying templates didn't work even though the fields can be added to the cubes.

Thank you for your expertise and kind regards
Philipp

Hi,

My understanding is that you want to select specific data(task dates) to export within a category (OLAP cube). Am I right? If yes, please try the follow steps:

• On the Reports tab, click Visual Reports.

• In the Visual Reports dialog box, click Save Data.

• In the Save Reporting Cube section, select the category that contains the type of data that you want to save.

• Click Field Picker to modify the fields included in the list of data to export. On the Visual Reports - Field Picker dialog box, click the fields that you want to add or remove from the list of data to export, and then click Add, Remove, or Remove All to move fields between the Available Fields and Selected Fields boxes, or between the Available Custom Fields and Selected Custom Fields boxes.Fields in the Selected Fields and Selected Custom Fields boxes are included in the exported data.

• Click OK on the Visual Reports - Field Picker dialog box, and then click Save Cube.

• Browse to the location where you want to save the cube data, and then click Save.

https://support.office.com/en-us/article/Create-a-visual-report-of-Project-data-in-Excel-or-Visio-14f82a87-4853-4ba2-9f16-09ac1723240a (It also applies to Project 2013)

If I misunderstood something, please feel free let me know.

Regards,