Browse by Tags

PerformancePoint Planning - Data change tracking / audit trail

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 track of all these changes plus a whole host of other...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 06-30-2008
SQL Server Utilities

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 !

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 06-10-2008
LINQ and SQL Server

Some time ago I reported on LINQ whilst Visual Studio 2008 was still in BETA. On Monday, Nov. 19 2007 , Microsoft announced that Visual Studio 2008 and the .NET Framework 3.5 was released to manufacturing (RTM). Since then I am sure many of you have had many hours playing with VS 2008, WPF, Expression...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 02-29-2008
PerformancePoint Server and SQL 2008

So after many hours looking into this issue, it seems that the current release of PPS does not work on SQL Server 2008, and there seems to be no tricking it. Should you manage to get round the install checks, while setting up the Database Connections to SQL and Analysis servers, the versions are checked...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 01-29-2008
MDX Stored Procedures (Part 2)

What seems like a lifetime ago I posted about MDX Stored Procedures and how we've built a helper class that provides a wrapper to an MDX query. The helper class has been stable for quite sometime now and a few people have been asking me when I'm going to release it. Well, today is the day. You...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 11-20-2007
Install SQL Server 2005, After 2008

So, if like me, you wanted to look at SQL 2008, and thought it best to totally remove 2005, and then install 2008 (Katmai), then realising that the Katmai BI tools did not install properly, you may want to re-install 2005. If have got to this stage you may have found and annoying installation bug, even...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 10-24-2007
PPS Planning - Force Cancel Check Out Functionality

You've been badgering away at a PerformancePoint Server Planning Model all day, updating objects, writing complex MDX scope statements to satisfy obscure business requirements and you've only got to add a new view to the time dimension before you can deploy and start testing when you find that...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-29-2007
Basket Analysis using Analysis Services 2005

My job is pretty varied these days :o) Today I've been looking at satisfying some basket analysis type requirements where, for example, we need to determine what other products customers have bought in addition to a known product. We could have used data mining for this but decided not to as, in...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-22-2007
MDX Stored Procedures (Part 1)

UPDATE: You can find part 2 here , along with a link to download a C# quick start. A long time ago I realised that inevitably, however well specified the requirements or however tight the deadlines are, clients always throw a curve ball. To that avail, like many, I adopt an agile approach to project...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-17-2007
XML Namespaces and the ADOMD XML Reader Result Set

I'm building a generic helper class to flatten an ADOMD data set to a data table for easier consumption by default and third party .NET controls. I can't rely on the Load method of the data table, nor the CellSet object as in some cases not all the information is persisted; datatypes and top...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 07-31-2007

Page 1 of 2 (14 items) 1 2 Next >