O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Allocating non-allocated company expenses to departments

There are two types of expenses; direct and indirect. It is relatively easy for any company to allocate a direct expense to a corresponding department because it actually happens in that department and is in no way associated with other departments. This type of expense is usually allocated in real time when it enters the system. An example of such an expense is salaries.

The other type of expense is an indirect expense, for example, an electricity or heating bill. These expenses are usually entered in the system using a special department like the corporation itself, a common expense department, or simply nothing (a null value). The company, to have a clear picture of how each department ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required