My friend Carl posted this as a comment to one of the longer threads on Analysis Services and Project Server with the ActiveX Component Can’t Create Object. error – but thought it worthy of top billing and a fresh post, as I know others have struggled with this one. Your mileage may vary and I […]
I posted a while back about an issue where the Application Server had an alias for the SQL Server, but when the Analysis Services cube build was requested the alias was passed to the Analysis Services server and it didn’t know the SQL Server by this alias (even if it was in fact the same […]
This came out of a recent Project Server support case where a customer was trying to show the capacity of resources by department in a Data Analysis view, but found that the filter for the resources department (a resource level field) wasn’t working as expected. If capacity wasn’t shown then the department filter was good […]
Mike Plumley from our UA team has done a great job in producing some walkthrough screencasts of a Project Server 2007 farm installation and also configuration of OLAP. These follow TechNet articles but show you all the steps involved. They are available for download as wmv files. Installing Project Server 2007 (four parts) Using SQL […]
This was a recent support issue with great work from Kate and Shazeb in getting to the resolution. Getting either of them to take credit was a harder job – so they get to share. The scenario is – you create a project plan, publish and create a workspace, then go to that workspace and […]
This podcast is a talkthrough of the process of building a cube. I forgot to mention firewalls which can also block access to SQL/Analysis Services – so see the TechNet artilces for details. For other blog postings on this topic go to http://blogs.msdn.com/brismith/archive/tags/Analysis+Services/default.aspx.
That may seem like a strange title, but for Project Server 2007 users of the Analysis Services features this is good news indeed! Along with the release of SP3 (see Christophe’s blog for more details) is the release of the latest Feature pack for SQL Server 2005. This includes the update to Management Object Collection […]