Here you’ll find source code, applications, and/or utilities available for download, that are discussed in the blog posts.
Neither Purple Frog Systems Ltd nor the author will accept any liability for any errors, problems or loss of business arising as a result of downloading or using any contents of this blog. Before downloading or using any of these files, please read the disclaimer in full here.
Automated SSAS Cube Documentation in SSRS
The following zip file contains the SQL script and SSRS .rdl files for use with SQL Server 2008 R2 in conjunction with the OLAP cube documentation blog post here.
Loan Amortisation in SQL Server (PMT, FV, IPMT, PPMT)
There are a number of functions available to Excel users that calculate loan repayments, interest, future loan value etc. Unfortunately these are not available in SQL Server.
To overcome this, the Purple Frog team have written a .Net CLR library which add four loan amortisation functions to SQL Server, which can be called from within a query as scalar functions.
For more details of the functions, please look at the loan amortisation blog post here.
You can download the files below:
We hope these are of some use
The Frog Blog
I'm Alex Whittles.
I specialise in designing and implementing SQL Server business intelligence solutions,
and this is my blog! Just a collection of thoughts, techniques and ramblings on SQL Server, Cubes, Data Warehouses, MDX, DAX and whatever else comes to mind.
FREE Full Day SQL events!
