Adatis Community

I'll be giving a talk titled 'PEL Vs MDX' at the UK SQL Server Community's BI Evening on the 17th July at Microsoft's TVP offices in Reading. The content will be geared towards MS BI developers, and will highlight the differences between...

PerformancePoint Planning does contain auditing out-of-the-box.  However, it's not data level auditing but instead Metadata level auditing.  If you want to track when a user has been added, or a workflow cycle started then PPS-P keeps a...

So, one of my previous posts I explored using PPS with SQL 2008 Feb CTP.  Now with the release of PPS SP1 and SQL RC0, I thought a perfect time to re-test the installation.  With a complete new installation of Windows Server 2008, SQL 2008 RC0...

If you subscribe to our combined feed you might have already spotted that we have a new member of the Adatis community.  Richard McSharry joins us as a principal consultant specialising in Enterprise Data Warehousing using the MS BI stack and his...

If you're like me, you're probably quite used to seeing - and being thankful for - those little red x's and yellow triangles on your transforms in SSIS. I've always wondered how SSIS knows something is wrong and today stumbled across this...

We recently had to turn a couple of demo boxes into a 2 client development environment for an overly aggressive PPS-P deadline.  Both demo boxes were connected to the network and both were PPS-P Servers.  We wanted to nominate a specific box...

PerformancePoint gives you the flexibility to have multiple assumption models to use as you please in your main models. Although this is great, I've found a problem when the two assumption models have different member sets for the same dimension,...

Don't tell MSFT I said this but this is really quite cool: http://code.google.com/apis/chart/ The Google charts API allows you to create charts as a web page by simply setting the querystring: http://chart.apis.google.com/chart?chs=400x200&chd...

Microsoft have just released Cumulative Update 8 for SQL Server 2005 Service Pack 2. Amongst the changes are a few fixes for small problems in Analysis Services, such as: Infinite recursion occurs in the CalculationPassValue function in SQL Server 2005...

In April I wrote about Reporting Services in SQL 2008 with MOSS 2007 ( here ), and also a small article on the SQL 2008 feature pack February CTP.  This was all tested on the February CTP, of SQL 2008.  The feature pack is required to get the...

XLCubed Version 4 was recently released, adding support for increased data visualisation via MicroCharts, as well as enhanced web publishing. I've been using XLCubed since version 1 and have always found it both powerful and easy to use. All the standard...

Andrew has posted a great list of community developed utilities for SQL Server .  There is a few on there that have been on my 'must-do-one-day' list for far too long !

What a treat, I am sure you have all already heard the SP1 has been released for PerformancePoint, which hopefully will enable us to run PerformancePoint on SQL Server 2008.  As well as this it seems that RC0 has been released on TechNet for SQL...

This will be cross posted all over the place but Service Pack 1 has now been released! Details from the PPS Technet Forum : PerformancePoint Server 2007 Service Pack 1 (x86):  http://www.microsoft.com/downloads/details.aspx?FamilyId=28B1F86B-B7F2...

There's a new tool for PerformancePoint Planning that allows you to migrate reference and fact data between applications. (It is designed to be used for first time migrations only) Documentation here Download here