Map Archives - Purple Frog Systems

PySpark Problems: Using Map() gives the error “TypeError: unsupported operand type(s) for /: ‘Row’ and ‘float’ “
March 31^st, 2023 in Azure, Big Data, Blog, Python, Spark
Here’s the first in what will be an adhoc series of short blog posts where I will write a paragraph on the solution to problems I come across when I’m using PySpark. In this post I will discuss using the Map() function to apply a function to every value in an RDD and then getting the error message: “TypeError: unsupported operand type(s) for /: ‘Row’ and ‘float’ “ We see this error because we are…
» Read more
Map Postcodes in SSRS Reporting Services
March 5^th, 2012 in Blog, Reporting Services
I was asked the other day for some help on how to plot data by postcode on an SSRS spatial map. I’ve done this a few times, initially for a presentation I gave back in 2010 and most recently a couple of weeks ago when I wanted to analyse the SQLMidlands membership. It occurred to me that despite posting a number of blogs using spatial data, I’ve not done one on the basics of plotting postcode data. So here we go… Scenario You…
» Read more
OLAP Cube Documentation in SSRS part 3
September 29^th, 2010 in Analysis Services, Blog, Business Intelligence, Reporting Services, SQL Server
This is the 3rd and final post in this series of blog posts, showing how you can use SQL Server Reporting Services (SSRS), DMVs and spatial data to generate real time automated user guide documentation for your Analysis Services (SSAS) OLAP cube. Part 1 – Creating the DMV stored procs Part 2 – Create the SSRS reports Part 3 – Use spatial data and maps to create a star schema view Download Source Code UPDATE: I presented a 1…
» Read more
OLAP Cube Documentation in SSRS part 2
September 27^th, 2010 in Analysis Services, Blog, Business Intelligence, Reporting Services, SQL Server
In my previous post I described how to create a number of stored procedures that use Dynamic Management Views (DMVs) to return the metadata structure of an SSAS 2008 OLAP cube, including dimensions, attributes, measure groups, BUS matrix etc. In this post I’m going to use those procs to create a set of SSRS 2008 reports that will serve as the automated documentation of your cube. I’m going to make the following assumptions:…
» Read more
OLAP Cube Documentation in SSRS part 1
September 25^th, 2010 in Analysis Services, Blog, Business Intelligence, Reporting Services, SQL Server
Being a business intelligence consultant, I like to spend my time designing data warehouses, ETL scripts and OLAP cubes. An unfortunate consequence of this is having to write the documentation that goes with the fun techy work. So it got me thnking, is there a slightly more fun techy way of automating the documentation of OLAP cubes… There are some good tools out there such as BI Documenter, but I wanted a way of having more control over…
» Read more

Alex Whittles (MVP)
Jeet Kainth
Jon Fletcher
Nick Edwards
Joe Billingham
Lewis Prince
Tom Owen
Callum Bryant
James Snow
Laura Adamson
Annabel Hemingbrough
Hollie Whittles

Tag Archive: Map

PySpark Problems: Using Map() gives the error “TypeError: unsupported operand type(s) for /: ‘Row’ and ‘float’ “

Map Postcodes in SSRS Reporting Services

OLAP Cube Documentation in SSRS part 3

OLAP Cube Documentation in SSRS part 2

OLAP Cube Documentation in SSRS part 1

Authors: