Semi Additive Measures using SQL Server Standard
One of the most frustrating limitations of SQL Server 2005 Standard edition is that it doesn’t support semi additive measures in SSAS Analysis Services cubes. This post explains a […] Continue Reading…
Sky Anytime – Killing Kontiki
I think it’s about time for a good old rant. Nothing to do with Business Intelligence, but…
Anyone out there who uses Sky Anytime (and I believe the BBC iPlayer) […] Continue Reading…
Extract Datasource and Query from Excel Pivot
Have you ever tried to reverse engineer an Excel pivot table? It’s not as easy as you would think! Whether you just want to find out the datasource details, […] Continue Reading…
Report Parameter Selection Memory
This post explains a method of enhancing Reporting Services reports to make them more user friendly. I have been quizzed many times by end users who want reports to […] Continue Reading…
Open SSRS report in a new Window
There isn’t yet a built-in facility within Reporting Services to open a report link (i.e. a drillthrough report) in a new browser window or tab, however it isn’t too […] Continue Reading…
Excel Addin for Analysis Services
For any users of Analysis Services, if you haven’t already downloaded the Excel (2002/2003) addin you’re missing out.
It’s a free download from Microsoft which significantly expands Excel’s cube querying […] Continue Reading…
Convert MDX fields to SQL
A number of our customers have reporting systems that use both MDX and SQL, retrieving data from both OLAP and SQL Server databases. This generates the problem of converting an MDX […] Continue Reading…
Chris Hays Reporting Services Sleazy Hacks
It really wouldn’t be fair to kick off the Frog-Blog without a shout out to Chris Hays and his superb ‘Sleazy Hacks’ site. If you want to push SQL Server […] Continue Reading…
The Frog-Blog is open for business!
Well, what can I say – the very first Frog-Blog post.
Keep checking back often for new and (hopefully) useful info…
Alex
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
