Style Sheets with Reporting Services
Firstly sorry for not posting anything for a while, I can only blame spending too much time working and on my uni assignments – not much time free these […] Continue Reading…
Dynamic MDX in Reporting Services
After a couple of days off work last week with SQL Bits III and SQL 2008 Unleashed, it’s back to the grindstone this week; however before I get onto […] Continue Reading…
Mosha's MDX Studio
I almost feel embarrassed…, I’ve been writing this blog for over 9 months now, and I have yet to mention Mosha, although in my defence, there is a link […] Continue Reading…
SQLBits III and more…
Next week we’re lucky enough to have a double-whammy of SQL events in the UK, has Christmas come early?…
On Wednesday 10th September, Microsoft are running a live Technet event, […] Continue Reading…
Use Stored Procedure Output Parameters in SSRS
It’s commonly known that there are a few frustrations when using stored procedures as the source for SSRS 2005 datasets, the inability to cope with temporary tables is always […] Continue Reading…
Ranking results from MDX queries
This post explains how you can create a ranking of data from an OLAP MDX query. This will take the results from the query, and assign a ranking to […] Continue Reading…
SSRS Report Performance monitoring
Today’s Frog-Blog top-tips are quite simple ones, but ones that I always find very useful. SSRS Report Performance monitoring.
Once you start to build up a few Reporting Services reports, […] Continue Reading…
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…
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 |  |
| Joe Billingham |  |
