WARNING! Epic 3 piece blog incoming!
To atone for my radio silence last week, I put together a 3 piece blog of a customization I modelled and executed for a GP customer. To keep us from having to look at arcane table names, I simplified and adjusted to a standard NAV implementation.
I apologize in advance, some of the execution phase whizzes by, but I wanted to limit myself to 15 minutes from start to finish. If you have any additional questions about the project or what we can do to customize your Jet Enterprise project, don't be a stranger! Shoot me an email at firstname.lastname@example.org
Having modelled the problem, we explore the first way of presenting the data.
In Part 2 we add a Foreign Key (Expense Type) to the Fact table, and then define a new dimension table (Expense Type).
All this is brought into the Finance Cube so that our final product has the ability to pivot the measure Amount around a new Dimension.
In Phase 3 we look at an alternative way of presenting the data.
Instead of segmenting the data using the Expense Type dimension, we create new measurements for each of the Expense Types on the Fact table and then pull those measurements into the Cube as Standard Measures.
With Standard measures in place we now have a multitude of options for the End User.
They can choose to consume the data by pivoting on Expense Type (as described in Part 2) or we can expand on our work in Part 3 by adding Calculated Measures or Business Functions!
We have the option of implementing ratios ex. Fixed Expense / Variable Expense.
This would be particularly useful if we had a Quantity measure!
Because we have standard measures, we could additionally explore comparison of time periods (ex. YTD, MTD, or Prev YTD).
The sky is the limit! And really that's the best thing about Jet Reports Jet Enterprise product!
Thanks for taking the time to read through the post! I look forward to hearing from you and perhaps seeing what Onyx Reporting can do for your company!