ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

Jet Enterprise - Working with Measures and Business Functions

10/12/2014

0 Comments

 
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.

Picture

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.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters