Posts Tagged ‘Business Intelligence’

#SP2013 #PS2013 and Business Intelligence TechNet links

October 31, 2012 Leave a comment

Just a few useful links from the newly released / updated TechNet articles around SharePoint, Project Server and BI in 2013

SharePoint 2013

Project Server 2013


Business Intelligence within SharePoint 2013

Excel Services


Visio Services

2012 SP1 CTP4 is out and RS2012 installation details here:

SQL Server 2012 BI – includes links to Report Builder, Power View and PowerPivot help

Reporting Services 2012 Developers Reference

Hardware and Software requirements for Reporting Services and Power View

Supported Reporting Services with SharePoint combinations

Reporting Services add-in locations

Feature support for rs2012 Native vs. SharePoint

Reporting Services 2012 feature availability comparison with different SQL Server 2012 editions


Useful findings whilst learning Reporting Services with #SP2010 #SharePoint #PS2010 #ProjectServer

So the first phase of the project I have been on for the last year is starting to move into the closing phases.  The information architecture is in place, most of the custom development is complete and mapped to the project lifecycle / business processes of my client.

The project takes data from multiple places including:

  • SAP (Resource, cost rate, metadata and product contract information)
  • Project Server 2010 (Timesheets, Plans, Project / Task / Assignment data)
  • SharePoint 2010 (Risks, Issues, Actions, Documents etc.)
  • Custom database (Snapshot data)

I’ve learnt a lot about SharePoint 2010 and Project Server 2010 since I started this project (pre public beta).  So now that we have all this data, the time has come to bring it all together with Business Intelligence dashboards and UI design.

Once of the main tools we are using for this is Reporting Services in SharePoint Integration mode and although I have lead projects involving SSRS in the past, actually getting my hands dirty and creating reports myself is something of a novelty.

However, time and resource pressures have meant that I have had to setup the SSRS infrastructure, development environments and test reports to ensure that the data can be utilised in the required way.  As part of this setup I am also training my client on the business intelligence studio interface and deployment of reports in to SharePoint environment.

So getting to the point of this post, below is a list of useful links, findings and discoveries I have made during this setup process this week to serve as a reminder to me and will hopefully help others too.


Reporting Services Web Part – Firefox Compatibility (Windows, Linux – 3.6.13)

  • Turn off Asynchronous data (Edit Web Part Settings > View Section)

NB: If this setting is left to its default, the loading screen does not go away until you hit the refresh button on the Web Part toolbar.


SharePoint Integration Mode – Linking to pages within SharePoint

It would appear that the Reporting Services web part in SP2010 disables links where the target URL is within SharePoint itself (“/pages/default.aspx” for example).

This blog post suggested a useful workaround:

However the suggested approach was good if you had a definitive URL such as default.aspx, but if you wanted to add a query string parameter based on the data returned, adding as action directly to the image did not allow me to select the appropriate date.

To get round this, I added a calculated field to the data set using the same process suggested in the post:

="javascript:void(window.location.href='/pages/projectdashboard.aspx?projectid='" + dataset.fields[<field name>] +")"

NB: Since working this out, I have extended it to use a standard JavaScript function that is running from the Master Page to make links in the reports more generic.

Then for the action on the image I was able to select “Go to URL” and select my calculated field.

This doesn’t work in the designer preview (or any exports of the report), however it works a treat when you are using the report as part of a dashboard with drill down features.


Interactive Column Sorting

Another useful blog post:

Although the instructions are for SSRS 2005, it is still relevant today.

  • Right click on the column header field
  • Select Properties
  • Interactive Sort Tab
  • Select the appropriate sort field
  • Click OK


Alternating Row Colours

Always a popular choice for tabular based reports.

Highlight the data row and under the properties pane for the background color, use the following expression:

=IIf(RowNumber(Nothing) Mod 2 = 0, "#F7F7F7", "#FFFFFF")



MSDN Documentation Links

NB: Although a lot of the above links are for SSRS 2008, there is an option at the top of the page to make the content relevant for SSRS 2008 R2 also.

#SP2010, #Project Server – Reporting Technologies vs. Data Sources

November 13, 2010 2 comments

Recently I have been teaching myself PerformancePoint 2010 and connecting it to the Analysis Services cube as part of Project Server 2010.

During my investigation, I started thinking about all the Business Intelligence options that are available within the SharePoint / Microsoft stack and thought I would map out what I know so far.

Please bare in mind this is work in progress based on what I have personally used as part of my projects over the years and research on MSDN / TechNet and other sources.

I will be gradually updating this as I learn more about the technologies and I welcome any input from the SharePoint / EPM community.

Work In Progress - Reporting Technologies vs. Data Sources

Notes against the items can be found in the attached Excel spread sheet below:

PerformancePoint 2010 error resolved “Code blocks are not allowed in this file” #in #sp2010

November 1, 2010 3 comments

I’ve been playing with PerformancePoint 2010 today and one of the first hurdles I came across in our MOSS 2007 upgraded environment was the following error:

An error occurred during the processing of /PerformancePoint/Pages/ppssample.aspx. Code blocks are not allowed in this file.

This seemed to be an issue with the following reference not being in the web.config on the site.

<PageParserPath VirtualPath="/PerformancePoint/Pages /ppssample.aspx" CompilationMode="Always" AllowServerSideScript="true" />

Once this was in, the error was resolved and I could install the Dashboard Designer as standard.

%d bloggers like this: