Dodeca Blog Series / jason w. jones

Views & Reports

Multiple Retrieves in Dodeca: a bread and butter Dodeca feature, having multiple data retrievals on a single view
Dodeca Technique: Multiple Essbase Data Sources in View: Multiple different Essbase connections/retrieves in a single view
Cascading Reports with Dodeca: setting up cascading reports so the user can select multiple choices from one or more dimensions and build reports for all of the combinations
Cascading Report Summary Sheets in Dodeca: using the “summary sheet” feature in Dodeca to get a dynamic summary of selections from the users’s cascade
Dodeca Technique: Essbase View with Cascaded Transaction Details Tabs: cascade across multiple different tabs
Dodeca Dynamic Grouping with Relational Data: how to put relational data into a view and have it automatically be grouped, with custom formulas for each group, Excel outlining, advanced formatting, and more.
Dodeca Techniques: Dynamic Rolling Quarters: Easily implement dynamic rolling quarters/periods in a Dodeca view
Dodeca: Turn on Auto Build button by default or hide it entirely: turn the Auto Build button on automatically
My Favorite New Dodeca 7.3 Feature: Outline Viewer: How to setup an Outline Viewer view type for presenting outline views as rich as those shown in EAS
Dynamic Essbase Connections in Dodeca: Faster Cubes and an Enhanced User Experience: Dynamically select the Essbase connection and transparently show/hide data from an alternate history cube (or other cube)
More on Dodeca Dynamic Connections: Allowing Users to Select Multiple Connections: Allow the user to select their own Essbase connection to use in a given view
User Selectable Cube Connections in Dodeca: allow user to select their own connection
Simple Drill-through in Dodeca: Simple drill-through implementation in a Dodeca view

Selectors

Dependent Selectors in Dodeca: dynamically update selector choices based on another one. This example demonstrates having a list of states, then when the user chooses one, a list of cities particular to the selected state is updated
Dodeca: Create and use a new Essbase MDX Selector List: Setup and configure a selector list based on MDX scripts

Data Input

Data Input with Dodeca, part 1: simple Essbase data input example with Dodeca
Data Input with Dodeca, part 2 – Comments: how to use the comments functionality in Dodeca so that users can provide descriptions of their input (often used with forecast/budget variances and related activities)
Data Input with Dodeca, part 3 – Data Audit Log: viewing the Dodeca Essbase data audit log, as well as building a view to report on updated cells from users
Data Input with Dodeca, part 4 – Focused Calcs: input to an Essbase cube from a Dodeca view, then running a focused calculation script upon input in order to update the cube
Data Input with Dodeca, part 5 – Relational Database input: relational input with Dodeca, including updating, adding, and deleting rows in a view
Data Input with Dodeca, part 6 – SQL and Essbase Hybrid Input in one View: an approachable, yet extremely advanced use-case, possibly unique to Dodeca: relational input on a view, then dynamically updating the corresponding intersection in a cube, all on a single view
Handy Essbase Data Audit Log Query for Dodeca Repository: SQL query for querying Dodeca repository’s audit log tables to determine the exact Essbase intersections that have been updated by users

Workbook Scripts

Dodeca Zebra Striping with WBS Example: apply greenbar/zebra striping to a data area with some simple WBS
Dodeca Workbook Script documentation available online: the Dodeca Workbook Script (WBS) developer documentation contains a reference to all events, methods, and functions available in WBS.

Misc

Vess + Dodeca for Substitution Variable Management: an innovative look at using the Vess Essbase JDBC driver along with a standard Dodeca SQL-editing view to update substitution variables on an Essbase server
Dynamic Calendar with Comments in Dodeca: a full calendar implemented in a spreadsheet that is dynamically generated based on selected dates and contains user-editable content!
Understanding Dodeca Tenants: what is a Dodeca tenant?
Dodeca Techniques – Auto Load Windows User Name During Relational Input: use the currently logged in user’s name as part of a data query
Multiple Applications in Dodeca: how multiple applications fit into a single Dodeca tenant
A primer on relational data views in Dodeca: first steps and configuration for SQL Passthrough DataSets in order to use them for viewing/inputting
Towards Spreadsheet Management: general thoughts on the notion of spreadsheet management