Shortcut your Sharepoint Business Performance experience with this pre-packaged virtual machine available for partners and customers, pre installed with industry specific Sharepoint dashboards like Education, Energy and Communications. If you get along to http://mssalesdemos.com/DefaultAnonymous.aspx you will find some online demo’s but this one is a full downloadable virtual machine – ok it is only Sharepoint […]
PowerPivot for Sharepoint 2013 supports a variety of different installation architectures – one of which allows you to run the PowerPivot Analysis Services instance on a server other than your Sharepoint 2013 server. You still need to install PowerPivot software on your Sharepoint server, however only the spPowerpivot.msi package (or on all Sharepoint servers […]
Less than 10 easy steps to create a Sharepoint Self Service Business Intelligence Navigation menu like this… A link to PowerPivot will open your PowerPivot Site, Dashboard Designer will open your Performance Point Dashboard Designer, and the third item in the menu is for the Report Builder 3.0 click once application. First, open your site, […]
You want to find the rsReportServer.config file for your SQL Server Reporting Services 2012 Installation. Basically….for a Sharepoint Integrated Mode install of Reporting Services look in … Typically the location of your reportserver url is going to look something like this if your sharepoint web url is http://yourserver.com.au … and for a Native Mode Reporting Services installation look in … […]
There are a myriad of point and shoot forecasting and planning tools out there however the Microsoft Business Intelligence stack has capabilities in this area too. You may already have some Microsoft infrastructure so its worth looking what you can do in Sharepoint, Excel and the other Microsoft BI tools before you go and […]
You can run a PowerPivot 2012 (v2) Excel 2010 document up on Sharepoint 2013 server. The following read outlines a the pros and cons. Note Excel 2013 Powerpivot documents support Interactive refresh within the open workbook however PowerPivot v2 for Excel 2010 only supports Unattended Refresh. At this stage I havn’t any luck getting […]
Those integrating Reporting Services with Sharepoint 2013, note you need the 2012 SP1 add-in for this to be successful. Otherwise you may find your Sharepoint Powershell commands Install-SPRSService and Install-SPRSServiceProxyCommands won’t work. http://msdn.microsoft.com/en-us/library/gg492257.aspx Happy Days !
An excellent concise summary of the feature differences between the editions of the new Sharepoint 2013 http://talbottcrowell.wordpress.com/2012/11/27/whats-new-in-sharepoint-2013-editions-comparison/. Note Business Intelligence still requires Enterprise edition but some interesting changes to the definition of internal vs external users with the former requiring license CALs and the latter not… http://www.degdigital.com/blog/big-changes-in-sharepoint-2013-licensing-for-portal-clients/.
A good article outlining the location of end points in Reporting Services 2012 integrated mode and how the various bits and pieces talk to each other. http://blogs.msdn.com/b/jtarquino/archive/2012/06/13/sql-server-reporting-services-2012-sharepoint-integrated-mode-endpoints-architecture-or-how-our-services-talk-each-other.aspx Includes an outline about how to check the Sharepoint Timer job which is used for Reporting Services 2012 Alerting. http://blogs.msdn.com/b/jtarquino/archive/2012/05/07/the-sql-server-reporting-services-2012-timer-job-in-sharepoint-mode.aspx If you are looking for Log files, these […]
A simple but intuitive requirement in a report is the ability to restrict the 2nd parameter values based on what you selected in the 1st parameter. Such an example might be to restrict the list of Staff depending on the Office you selected previous. In Performance Point this is known as Cascading parameters and was […]