In this webinar I wanted to review a crucial but oft forgotten element of Jet Enterprise, the (free) Business Function Library. I was keen to explain what it's about and how it relates to the measures that you're manipulating in your Pivot Tables in Excel.
The Business Function Library allows you to rapidly implement Measures (the Values section of Pivot Tables) that are parameterized as well as contain logic to protect from errors. This is particularly useful when working with Ratios or in environments where you don't have an MDX resource in house that can write custom code for you! After all, one of Jet Enterprise's key value proposition is ease of use and implementation.
In this first video we model and discuss the 3 types of measures.
In the second video I show you how to install and use Business Functions.
If you need the steps for installation written out, please take a look at Jet Reports' knowledge base article. It's well written and documented.
We then follow up with an example if implementing YTD and Prev YTD measures on a stock GP project using "Parallel Period" and "Year to Date (YTD)".
Please note, the current GP project in the Enterprise CubeStore uses "Periods to Date (XTD)" business function.