
Calculate SumProduct in Essbase Using MDX
Justin Biard on Essbase, MultiDimensional eXpressions, HyperionIn Microsoft Excel you can calculate the sum of products (A x B) for multiple lists of numbers (arrays) using a formula such as =SUMPRODUCT(D3:F3, D4:F4). Some common examples of when you may need this include weighted averages or an accumulated sum of products (quarter or year »