Lately I have been working on new materials and demo ware to help show off the power, flexibility, and sophistication of both the Dodeca Spreadsheet Management System and Drillbridge/Drillbridge Plus. I came across a really great Drillbridge mapping example today that I hadn’t specifically solved before, but with a little creativity I was able to write the proper Drillbridge query and get exactly what I wanted.
Consider an Essbase cube with the following dimensions:
- Years: FY15, FY16, etc
- Periods: Periods/Quarters/Months
- Scenario: Actual, Budget
- Departments: balanced hierarchy with four levels
- Location: Total/Division/Store
- Measures: Ragged hierarchy with accounts at level-0
For this post I am going to design a Drillbridge query that maps from this cube back to its related relational data, with the additional wrinkle that we want upper-level drill in several dimensions, including one where the dimension in the cube is represented by two different columns in the source data.