• Home
    • About DBI
    • Award Winning Diver BI Software
    • Customer Commendations
    • The Team
    • DBI Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
  • Products
    • Diver | BI
      • Diver Workbench
      • Videos
      • Case Studies
    • Gap 360 Sales Analysis
      • Diver on demand in the Cloud
  • Applications
    • Property
      • Property Prices Ireland
    • Supply Chain
      • Retail
      • Wholesale
      • Distributor
      • Produce
      • Manufacturing
      • Autoparts
      • Transport
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • DI Program Advisor
    • Diversity
      • Waste management
      • Telecom Brokerage
      • Colleges & Universities
      • Economic Trends
      • Maps
      • Travel & Tourism
      • Parking
      • Smart Meters
      • Carbon Emissions Management
    • Healthcare
      • Healthcare
      • Pharma Applications of Diver
      • DI Surgery Advisor
      • DI Physician Performance Advisor
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile
      • DiveTab Mobile BI
  • Partners
    • Dimensional Insight
    • Diver BI Group
      • Envisage
      • Chartwell IT
      • Cloud-works Solutions Ltd
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pinnula
      • Formell
      • IBI
    • Zight – Partner for Transport
    • 24/7 Uptime
    • ID Technology (Brazil)
    • Infotool (Nordic Countries)
    • iXias Software – DI France
    • KDE Group (Israel)
  • Services
    • SaaS
    • Training
    • Support
    • Software Development
    • Consultancy
  • Contact

DBI Dynamic
Business
Informatics

Home Articles Blog Business Rules

Business Rules

Tuesday 20th August 2013

The key to successful Business Intelligence

BI software providers like to talk about the features and functions of their products. However, the real quality of your BI deployment often rests in the expertise of your BI vendor (or in-house BI specialist) and the ability to effectively translate your organization’s business rules into a BI solution.

In this blog post, we’ll discuss what business rules are, and give you some examples of how they need to be codified in your BI application.

What are business rules?

A typical BI application is designed around the business rules your organization uses to measure and achieve its goals and to govern its operations. The BI application takes information and presents it in the context of your organization’s business rules to give meaning to data.

Here are some examples of common business rules:

  • Business booked in a given quarter must be invoiced and shipped before midnight on the last day of the quarter, based on the local time zone of the global headquarters.
  • Overtime pay is calculated at 1.5 times the standard hourly rate of the employee. It is awarded for all time worked in excess of 40 hours in a week, in 15-minute increments, rounded up. A work week is defined as beginning at midnight Monday morning and ending at 11:59 PM the following Sunday night, based on the local time zone of the employee’s site office.

Business rules can relate to units of measurement, standards, targets, quotas, and metrics. Business rules can include data-dependent actions like alerts, compensation, payment terms, discounts, rebates or commissions. Some business rules are simple. Some are complex. And many business rules seem simple but translating them to BI transformation routines can be quite complex.

Your BI application must be powerful and flexible enough — and your consultant must be skilled enough — to codify the business rules and any exceptions. This separates market leaders from “wannabes.”

“Following the Sun” changes the data horizon too

But what if your organization has the added complexity of reporting on data transactions across multiple sites and across multiple time zones? What if your company is multi-national and must both consolidate and separate reporting across multiple currencies? Here the relative context is a moving target, and it takes a little more expertise to deliver a solution that takes into account these global dynamics.

This is exactly the challenge that faced Dynamic Business Informatics (DBI), founder member of the Diver BI Group, when we first engaged with Colin Burns, group commercial manager from H&K International. H&K is a company that delivers complete kitchen packages to new or existing restaurant sites anywhere in the world. With its global HQ in Dublin, H&K has 17 offices worldwide, spanning major time zones, including Toronto, Dallas, Detroit, Mexico, Beijing, Johannesburg, Tokyo, Beirut, Manila, Auckland, and Sydney. One of its key customers is McDonald’s, which operates 33,000 fast food restaurants in 116 countries. Its record with McDonalds is exemplary, with H&K winning both “Supplier of the Year Award” and “Partner of the Year Award” twice.

H&K needed decision-makers at each business unit to be able to look at their own data in a timely way in their native currency, but also allow the same data to be viewed as part of consolidated reports using either a European standard currency, U.S. currency or the group currency for Central Admin reports. In addition, the financial reports had to incorporate local business rules such as taxation.

How Diver’s ease of use and DBI’s expertise helped H&K manage business rules
Colin engaged with DBI after hearing of our work using The Diver Solution to consolidate reporting for other pan-European organizations. Colin says, “The spanning of so many time zones and areas with multiple currencies proved to be extremely challenging for our reporting needs. We considered implementing a new ERP to achieve this goal but it would have taken too long. We needed the information now, not in a couple of years’ time. We also had to consider cost and potential disruption to our business.”

DBI designed a BI application that extracts all the relevant sales, stock, purchasing, contracts and finance data out from each AS400 machine and consolidates it into a central virtual data warehouse. The “virtual” warehouse concept means the data is standardized and transformed using H&K’s consolidation rules before it is used to build models and reports. The virtual design is more flexible than a traditional data warehouse; this means that rules can evolve as new business units are added to the live environment. By using the virtual warehouse design, DBI could establish the first sites within days, without having to evaluate all the separate rules for each company beforehand.

Applying business rules at several levels.

Level 1
The first level was to apply business logic to create actionable reports on data coming out of all its separate Orion AS400 ERP systems at multiple sites. This was fairly straightforward and it’s the type of business analytics that we are all familiar with.

Level 2
The second level was to apply rules relating to time zones when consolidating all of this transformed data for reporting purposes.

Level 3
The third level was to apply rules relating to the various trading currencies, particularly the two base reporting currencies (Euros and U.S. dollars) for the head offices in Europe and the U.S.

The results

Prior to implementing Diver, any time one of H&K’s field offices had a new reporting requirement, it had to be developed, tested and implemented uniquely for that office, which was both costly and time-consuming. Now, business logic changes are applied centrally and are filtered down to all sites simultaneously, eliminating the need for separate rules at different locations.

In addition, if H&K wanted to create a report based on data across all sites, it previously took a long time with the old AS400 reports. Once users received the reports, they often forgot the reasons behind them because they took so much time to produce. Now with Diver, users are able to quickly create reports across locations so they can make business decisions in a time-sensitive manner.

Finally, the standardization that Diver provides enables Colin to analyze data across the globe and be confident that reports in say, Ireland and Australia, are based on comparable information.

H&K now automatically delivers more than 300 Diver reports daily. Each site receives reports at the start of business in its own location and in the currency it wishes to see.

Colin said, “We are delighted with the efficiency and cost-effectiveness of the Diver application delivered by DBI. Although it appears to operate very simply, we realize that it has only been possible through DBI’s deep understanding of our business requirements and its ability to translate our business rules accurately.”

Key Takeaways from this post:

In this example we have seen that:
1. Applying business rules effectively to your BI application can make the difference between compliance and non-compliance, success and failure.
2. Business rule application starts with a quality consulting engagement.
3. The ability to codify business rules and apply them to your BI application is facilitated by a flexible and feature-rich BI product.

Learn why BI customers consistently rate Dimensional Insight and its global representatives at the top of the list among BI vendors on metrics including the quality of consulting engagement and the business value derived from BI in these independent analyst surveys:

  • BARC BI Survey 2012
  • 2013 Wisdom of Crowds® Business Intelligence Market Study

Debbie Lonsdale, DBI

Contact Debbie

Next Post

Latest News from DBI

  • Top Logistics Trends for 2022
  • Take a Look at the DIUC22 Agenda
  • Klas 2022 – A Grades for Dimensional Insight
  • Dimensional Insight Partner Conference – Leiden 2022
  • We’re Hiring!

DBI Accolades

  • Dresner Wisdom of Crowds 2022 – Best in Class Results
  • Klas 2022 – A Grades for Dimensional Insight
  • Dimensional Insight Earns Top Marks in 2021 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas 2021
  • 5 Takeaways from the 2020 Wisdom of Crowds Report

Dynamic Business Informatics Ltd

UK & Ireland Distributor of The Diver Solution, providing business consultancy services, products and applications derived from the Diver Solution.
14 Mellifont Avenue
Dun Laoghaire
Co. Dublin

+353 1 2302022

10 Kenyon Street
Nenagh
Co Tipperary

+353 67 43309

Contact Us

We would love to hear from you! Please submit your query and we will get in touch with you shortly.

Email addresses are never sold, rented, or shared. Please see our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.

DBI Blog

5 Business Intelligence and Analytics Trends that Are Shaping 2022

With the worst days of the pandemic (knock on wood) behind us and lockdown orders lifted, the world has finally started to adjust to the “new normal.” Now that organizations have begun to reorient their strategies to reflect the novel circumstances, new trends have begun to emerge in the field of data analytics and business intelligence (BI).More

  • How Hospitals Can Use Data to Go Green
  • All The “Cool Kids” Are Investing In Wine
  • Top Cybersecurity Investments for Healthcare in 2022
  • New Charts in Property Prices Portal

More Blog Posts

Copyright © 2014–2022 DBI · Privacy Policy · website by cubecolour

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.


What Are Cookies?


As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.


For more general information on cookies, please read "What Are Cookies".


How We Use Cookies


We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.


Disabling Cookies


You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies.


The Cookies We Set




  • Account related cookies


    If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.




  • Login related cookies


    We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.




  • Forms related cookies


    When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.




  • Site preferences cookies


    In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.




Third Party Cookies


In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.




  • This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.


    For more information on Google Analytics cookies, see the official Google Analytics page.




More Information


Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.


However if you are still looking for more information then you can contact us through our contact page

Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT