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

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...

#Odata #SQL SSIS component now available for SQL Server 2012 #ProjectOnline #SSRS #SharePointOnline #SharePoint #BI

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,...

#SSRS native report render issue in #SharePoint #SP2013 with #IE 10 or later #PS2013 #BI #SQL

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....

#ProjectServer #SSRS Report with multivalued parameters #SQL #PS2010 #SP2010

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...

#ProjectServer optimisations for #SQL Server and #PS2010 databases #SP2010 #MSProject

https://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx#Section6_3A quick blog post to show the recommended SQL Server and database settings for optimal performance of your Project Server environment. See the SQL queries below along with the TechNet documents for reference. SQL CLR: sp_configure 'clr enabled', 1 go reconfigure go Print 'CLR Enabled' https://technet.microsoft.com/en-us/library/ee662108(v=office.14).aspx#section3 SQL Server MAX Degree of Parallelism (Specific for SharePoint...

#SharePoint 2007 / 2010 and #ProjectServer 2007/ 2010 #BI Reporting made easy #SP2010 #PS2010 #businessintelligence #SQL

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...

#SharePoint 2007 / 2010 Reporting #SP2010 #PS2010 #ProjectServer #BI #businessintelligence #SQL

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...