Timephased data

Configure Rollup of Timephased Reporting Data in Project Online

Many organizations need reports that retrieve Tasks and Assignments timephased data. The problem is performance issues, especially in organizations that have a lot of Project Online reporting data. Microsoft acknowledged that not all organizations would need the timephased data to be reported by day. So they introduced an option to roll up the data on Read more about Configure Rollup of Timephased Reporting Data in Project Online[…]

6 things you need to know about Microsoft Planner, the new work management offering from Microsoft

Microsoft announced this week that Microsoft Planner is now generally available, and all users with eligible Office 365 subscriptions will automatically see the Planner tile appear in the Office 365 app launcher when it is available for them to use. Read more While there is lot of information beginning start circulating on the Internet, we Read more about 6 things you need to know about Microsoft Planner, the new work management offering from Microsoft[…]

Enable Promoted Links for Graphical Navigation in the Project Server Business Intelligence Center

The Promoted Links app in SharePoint 2013 is a great way to graphically display a list of animated navigation tiles, similar to the tiles that appear on the PWA home page: You can use the Promoted Links app to add your own animated graphical navigation tiles to the PWA home page, Project Sites, or even Read more about Enable Promoted Links for Graphical Navigation in the Project Server Business Intelligence Center[…]

Format Date Data for Accounting-Style “Year_Month#” Columns in Your SSRS Reports

So, you have a requirement to create a report on planned or actual cost data by month, by year, and your report requester would prefer that the column headings be formatted accounting-style, such as 2014_01, 2014_02, 2014_03, etc. No Problem! Place the following code into your SQL SELECT and GROUP BY statements, sum your cost Read more about Format Date Data for Accounting-Style “Year_Month#” Columns in Your SSRS Reports[…]

Capturing Performance Counters for SharePoint and Project Server into the Logging Database (Part 2)

Last Blog, I have showed you how to setup the performance counters for Project Server and SharePoint to start recording into the SharePoint Logging database. Today, I will walk you through how to query the data in the Logging DB to extract the performance counters and their values. The new Performance Counters we created last Read more about Capturing Performance Counters for SharePoint and Project Server into the Logging Database (Part 2)[…]

Indicator for Day of the Week.

I am sure many of you might have come across this request from clients who want to either implement a rule where certain tasks start on a particular day of the week (for example – Monday), or at least have some indication, which shows that the task is NOT starting on a particular day. Recently, Read more about Indicator for Day of the Week.[…]