#ProjectServer 2019 missing data in #OLAP cube? #SSAS #Reporting #Excel

November 29, 2019 at 10:56 pm | Posted in Administration, Configuration, Fixes, Functionality, Information, Installation, Issue | Leave a comment
Tags: , , , ,

Just a quick post and one related to Project Server on-premises which I haven’t done for a long time! A colleague escalated an issue to me where by data was missing in the OLAP cube in a new Project Server 2019 deployment. The symptoms where that data appeared to be missing from the Portfolio Analyzer cube. For example, adding Project List into the pivot table didn’t display any projects but when looking at the values in the Project List dimension from the Pivot Table fields menu you could see the projects:

excel

Adding the Project List to the Pivot table, no Project Names included:

excel2

If another cube was used such as the Project Non Timephased, the Projects displayed on the pivot table as expected. If the built in measures where removed from the OLAP cube configuration and the cube rebuilt, the Project List then displayed fine on any OLAP cube. The fix is a simple one, it relates to a the Reporting Timephased Data change that on new installs this is set to Never which is the same behaviour for new PWA site collections in Project Online. Change the Reporting setting to another option such as daily:

reporting

Then publish the projects, once the projects are published, ensure the built in measure are enabled as required in the OLAP cube configuration if you have changed these and set the OLAP cube to build. Once processed the OLAP cubes will all work as expected.

Introducing the reimagined Microsoft Project! #ProjectOnline #Office365 #PowerPlatform #PPM #ProjectManagement

September 10, 2019 at 2:09 pm | Posted in Administration, Configuration, Functionality, Information, Installation | Comments Off on Introducing the reimagined Microsoft Project! #ProjectOnline #Office365 #PowerPlatform #PPM #ProjectManagement
Tags: , , ,

There was a nice new message in the Office 365 message center today – Introducing the reimagined Microsoft Project! This can be seen below:

image

This includes a link to the published roadmap item: https://www.microsoft.com/en-gb/microsoft-365/roadmap?filters=&filters=&searchterms=54641 

Looking forward to the new Project going live!

#ProjectServer and #SharePoint 2013 / 2016 May 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

May 11, 2018 at 10:06 am | Posted in Administration, Configuration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 May 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 May 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4133083

Project 2016 May 2018 update:
https://support.microsoft.com/en-us/kb/4018373

SharePoint Server 2016 / Project Server 2016 May 2018 update: 
https://support.microsoft.com/en-us/kb/4018386 & https://support.microsoft.com/en-us/kb/4018381

The Office 2013 May 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4133083

Project Server 2013 May 2018 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4018395

Project Server 2013 May 2018 update:
https://support.microsoft.com/en-us/kb/4022130

Project 2013 May 2018 update:
https://support.microsoft.com/en-us/kb/4018379

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the May 2018 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 April 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

April 11, 2018 at 6:26 am | Posted in Administration, Configuration, CU, Customisation, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 April 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 April 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4098622

Project 2016 April 2018 update:
https://support.microsoft.com/en-us/kb/4018320

SharePoint Server 2016 / Project Server 2016 April 2018 update: 
https://support.microsoft.com/en-us/kb/4018340 & https://support.microsoft.com/en-us/kb/4018336

The Office 2013 April 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4098622

Project Server 2013 April 2018 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4018346

Project Server 2013 April 2018 update:
https://support.microsoft.com/en-us/kb/4018352

Project 2013 April 2018 update:
https://support.microsoft.com/en-us/kb/4018335

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the April 2018 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 March 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

March 16, 2018 at 6:22 pm | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 March 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 March 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4090988

Project 2016 March 2018 update:
https://support.microsoft.com/en-us/kb/4011734

SharePoint Server 2016 / Project Server 2016 March 2018 update: 
https://support.microsoft.com/en-us/kb/4018293 & https://support.microsoft.com/en-us/kb/4011687

The Office 2013 March 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4090988

Project Server 2013 March 2018 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4018301

Project Server 2013 March 2018 update:
https://support.microsoft.com/en-us/kb/4018305

Project 2013 March 2018 update:
https://support.microsoft.com/en-us/kb/4018292

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the March 2018 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 February 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

February 14, 2018 at 7:39 am | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 February 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 February 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4077965

Project 2016 February 2018 update:
https://support.microsoft.com/en-us/kb/4011672

SharePoint Server 2016 / Project Server 2016 February 2018 update: 
https://support.microsoft.com/en-us/kb/4011680

The Office 2013 February 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4077965

Project Server 2013 February 2018 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4011694

Project Server 2013 February 2018 update:
https://support.microsoft.com/en-us/kb/4011701

Project 2013 February 2018 update:
https://support.microsoft.com/en-us/kb/4011679

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the February 2018 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 January 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

January 13, 2018 at 9:13 am | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 January 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 January 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4058103

Project 2016 January 2018 update:
https://support.microsoft.com/en-us/kb/4011633

SharePoint Server 2016 / Project Server 2016 January 2018 update: 
https://support.microsoft.com/en-us/kb/4011642 & https://support.microsoft.com/en-us/kb/4011645

The Office 2013 January 2018 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4058103

Project Server 2013 January 2018 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4011650

Project Server 2013 January 2018 update:
https://support.microsoft.com/en-us/kb/4011654

Project 2013 January 2018 update:
https://support.microsoft.com/en-us/kb/4011640

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the January 2018 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 November 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

November 16, 2017 at 9:20 am | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 November 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 November 2017 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4051890

Project 2016 November 2017 update:
https://support.microsoft.com/en-us/kb/4011227

SharePoint Server 2016 / Project Server 2016 November 2017 update: 
https://support.microsoft.com/en-us/kb/4011243 & https://support.microsoft.com/en-us/kb/4011244

The Office 2013 November 2017 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4051890

Project Server 2013 November 2017 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4011249

Project Server 2013 November 2017 update:
https://support.microsoft.com/en-us/kb/4011257

Project 2013 November 2017 update:
https://support.microsoft.com/en-us/kb/4011235

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the November 2017 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 October 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

October 19, 2017 at 1:32 pm | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 October 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 October 2017 updates and cumulative updates are now available – post a bit later than normal, please see the links below:

https://support.microsoft.com/en-us/kb/4043461

Project 2016 October 2017 update:
https://support.microsoft.com/en-us/kb/4011141

SharePoint Server 2016 / Project Server 2016 October 2017 update: 
https://support.microsoft.com/en-us/kb/4011217 & https://support.microsoft.com/en-us/kb/4011161

The Office 2013 October 2017 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4043461

Project Server 2013 October 2017 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4011175

Project Server 2013 October 2017 update:
https://support.microsoft.com/en-us/kb/4011182

Project 2013 October 2017 update:
https://support.microsoft.com/en-us/kb/4011156

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the October 2017 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectServer and #SharePoint 2013 / 2016 September 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

September 13, 2017 at 9:24 pm | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 September 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 September 2017 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4040279

Project 2016 September 2017 update:
https://support.microsoft.com/en-us/kb/4011101

SharePoint Server 2016 / Project Server 2016 September 2017 update: 
https://support.microsoft.com/en-us/kb/4011127 & https://support.microsoft.com/en-us/kb/4011112

The Office 2013 September 2017 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4040279

Project Server 2013 September 2017 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4011115

Project Server 2013 September 2017 update:
https://support.microsoft.com/en-us/kb/4011118

Project 2013 September 2017 update:
https://support.microsoft.com/en-us/kb/4011109

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the September 2017 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

Next Page »

Blog at WordPress.com.
Entries and comments feeds.