A Basic Mondrian Cube: Introducing the Star Schema

star_schema

The previous post explained how to create a simple Mondrian cube. It is meant to provide the most basic information on how Mondrian cubes are created and stored. The previous solution uses only one DB table to store the entire cube. It uses only degenerate dimensions, to use Mondrian parlance.
This article builds on the basics already . . . → Read More: A Basic Mondrian Cube: Introducing the Star Schema

Accessing Kettle Internals with JavaScript

dbinfo

On rare occasions an ETL requirement comes up that is not easily implemented using the Kettle standard steps. Suppose for example that each record must be tagged with information about the database it is coming from. The source database is defined in the DB connection settings, but how to extract its current settings (i.e. type, host, port, dbname)? . . . → Read More: Accessing Kettle Internals with JavaScript