I haven't been doing much blogging lately; we are busy working on our business intelligence projects and are fortunate to have a full pipeline of BI projects (SQL, SSAS, SSRS, SPS, PPS and Silverlight). But, I truly believe if you are going to survive as a company, you either innovate or die. With that...
Posted to
Microsoft Business Intelligence Blog
by
Patrick Husting
on
Thu, Apr 23 2009
Filed under:
Filed under: PerformancePoint Server, Microsoft, SSAS, Reporting Services, Facts, Scorecards, MDX, Marketing, Performance Management, Reporting, Analytics, News, PushBI
So when you are building your PerformancePoint Server solutions, if you have everything on one machine it works great, but when you setup seperate machines, security always becomes kind of a pain. You need to setup Kerberos to setup trust between the web and database servers if you want the users credentials...
I found this over at the SQL Server Manageability Team Blog . It will help analyze your OLAP databases and give you recommendations for performance. It is worth a look... "The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA...
Microsoft has released a significant update for its widely used SQL Server database software. The company on Monday announced the general availability of SQL Server 2005 Service Pack 2 -- which contains a number of key enhancements to the software, including full Windows Vista and Office 2007 compatibility...
Just saw this on the Microsoft MSDN web site. Worth the download and read if you are doing OLAP work. http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc Regards Patrick
I noticed on the discussion groups the other day a question about hiding Row Members in BSM when there is no data in the row. Yes you can do this, but you need to use an MDX Expression to do it. There no checkbox to Hide rows within BSM, which would be a good feature for the next version of the Scorecarding...
Well, it was easier than I thought and now I have a HUGE task list of things I need to do to the site. I will be updating the look and feel of the content over the next couple months. Please be patient while I make these changes. Enjoy the new features Patrick