Modern Work Management – Project and the Power Platform blog
Microsoft Project, Project Online, Project for the Web and the Power Platform
It’s been a few weeks now since the Project Virtual Conference, for those of you that missed it, sign up here: http://projectvirtualconference.com/ and you can view the recordings. This post will give a summary of my session on Project Online BI Made Easy: http://event.projectvirtualconference.com/B002/ The aim of this session was to give an overview on... Continue Reading →
Quick post to reference my session for the Project Virtual Conference on 22nd October 2015: http://projectvirtualconference.com/sessions/project-online-bi-made-easy/ See some of the great reporting options for Project Online. For the full schedule see: http://projectvirtualconference.com/schedule/ To register for this great free event (no travel expenses either!): http://projectvirtualconference.com/register/
Microsoft recently released some great documentation and an example SSIS package on only pulling down the changes from Project Online to your custom SQL database – this will improve the efficiency of your Project Online SSIS packages. I recommend you take a look if you haven't already: http://msdn.microsoft.com/en-us/library/office/dn794163(v=office.15).aspx http://www.microsoft.com/en-us/download/details.aspx?id=43736 For a walkthrough of an example SSIS... Continue Reading →
Following on from my post earlier today regarding the SSIS component that enables you to extract data from ODATA feeds in Office 365, I have created a blog post that demonstrates this new functionality. See the steps below: Firstly I installed the SQL Server data tools and Integration Services feature on my Test Project Server... Continue Reading →
Quick post to let you know that the SSIS component to export data via ODATA that was mentioned here is now available for download, see the link below: http://www.microsoft.com/en-us/download/details.aspx?id=42280 This will enable you to copy data from Project Online into a custom SQL database, from there you can easily create SSRS reports, custom OLAP cubes,... Continue Reading →
This post covers an the details around an issue I came across the other day and I wanted to make you aware to help in your deployments / system design. The issue is with displaying SSRS Native mode reports on a SharePoint 2013 page using a page viewer web part when using IE 10 or later.... Continue Reading →
Recently while working on a client deployment we had an issue relinking the SSRS reports to the data sources within the same library – SSRS was in SharePoint integrated mode. We had developed the Project Server solution internally and migrated it to the clients environment at a later date. All worked as expected apart from... Continue Reading →
A quick blog post to highlight the use of one of the Project Server Reporting database functions to resolve an issue when using an SSRS multi value parameter. There are several methods to get multi value parameters working in SQL Server Reporting Services (SSRS) including dataset filters, joining parameters and custom SQL functions – other... Continue Reading →
Following from my previous post where I briefly introduced a new product from CPS called SharePoint ReportLink, as promised, this post demonstrates the ease of use and ease of reporting on SharePoint data when using SharePoint ReportLink. For the purpose of this blog post, I have already deployed the solution to my test VM. Worth... Continue Reading →
A quick blog post to highlight a new product that CPS have released. The product is called SharePoint ReportLink. Details for the product can be found below: http://www.cps.co.uk/What-We-Do/Pages/SharePoint-ReportLink.aspx http://www.cps.co.uk/What-We-Do/Documents/SharePoint%20ReportLink.pdf This product enables end users to easily create reports on SharePoint data using their favourite reporting technology without having to use the SharePoint web services. The... Continue Reading →
Modern Work Management - Project and the Power Platform blog 
You must be logged in to post a comment.