concept business question in category mondrian

appears as: business questions, business question, business questions
Mondrian in Action

This is an excerpt from Manning's book Mondrian in Action.

If you’re familiar with entity-relationship modeling, you’re probably wondering whether business processes are a kind of entity. Despite the fact that they’re stored as rows in a database, they’re not entities. Business processes happen on their own schedule, often outside the company and its information systems, and often don’t have a natural unique identifier. Without a unique identifier, they don’t qualify as entities in the classical sense of entity-relationship modeling. Consider an HR system: an employee is an entity, but every update to that employee (hiring, firing or resignation, promotion, pay raise, transfer to a different department) is an instance of a business process. Although these business processes involve the same entity, they’re different business processes and should be in different cubes. This is why the business question, to motivate the design of the dimensional model, is so important. The cubes you’ll need to build, such as [Employee Hires] and [Employee Transfers], are not obvious if you only look at the tables and columns of the operational database.