ADVERTISING EXPENSE = (PRODUCT A SALES/TOTAL CORPORATION PRODUCT A SALES) * ADVERTISING EXPENSE FOR PRODUCT A FOR BUSINESS UNIT XYZ
Here, Advertising is from the Measures dimension wherever it intersects with other dimensions (e.g., Business Unit, Product), but Product A Sales is more specific; it is Sales from the Measures dimension restricted to the Product A member from the Product dimension. The Advertising Expense to be shared is the Advertising Expense for Product A spent by Business Unit XYZ that the business units which have non-zero sales of Product A agreed to share. These references to several dimensions within the same rule make it a Cross-Dimensional Formula.
from OLAP Glossary, 1995
|DSS Home | About Us | Contact Us | Site Index | Subscribe | What's New|
|Copyright © 1995-2019 by D. J. Power (see his home page).
DSSResources.COMsm is maintained by Daniel J. Power of
PowerEnterprises.net. Please contact him at djpower1950 at gmail.com with questions. See disclaimer
and privacy statement.