Dynamic Reports using Build Range From Script

In this post I show how to create an Essbase report that automatically changes when your hierarchies change using Workbook Scripting.

Continue reading…

Creating an Essbase MDX Script

In this post I show how to create an Essbase MDX Script in Dodeca that can be leveraged in Workbook Scripts.

Continue reading…

Dodeca Data Audit Log Setup Part Three

In Part Three of Three in this series I will show how to add a right-click menu to an existing Essbase View in order to quickly lookup Data Audit Log information.

Continue reading…

Dodeca Data Audit Log Setup Part Two

In Part Two of Three in this series, I’m going to show how to set up a Dodeca View that will display Data Audit Log information.

Continue reading…

Dodeca Data Audit Log Setup Part One

All of the data that is submitted to Essbase using Dodeca is logged and auditable. It doesn’t matter if the data is sent to an ASO or BSO cube, it gets tracked. Sometimes it’s usefully or even necessary to know who updated a number and when it happened. In this three part series I’ll explain how to set this up.

Continue reading…

Creating a Book of Reports in Dodeca

A typical task for a financial analyst is to pull together a number of reports into a single workbook that tells a story. The story might show the progression from a higher level to a more detailed analysis or a number of different scenarios. In any case, putting together several reports into a single workbook can be done in Dodeca in a way that makes things easy for an analyst.

Continue reading…