Custom Calculations Are a Snap When Using MDX and OLAP
Brian J. Miles, Ben Zenick · 2009
This paper will address the use of MDX to develop custom calculations in OLAP that aren’t easy to implement or apply in reports based on standard tables. Have you ever attempted to apply if/else logic directly into an OLAP cube that will allow the engine to make certain decisions? Have you had difficulty applying Advanced Time Period Manipulation in an OLAP structure; like Year to Date or Rolling Year to Dates? Can you apply different calculations to a measure based on a certain level in a hierarchy? How can you deliver Non-Additive calculations in OLAP? This paper will address these questions as well as the following information custom options for cube building, using external aggregation tables, advanced MDX topics, and Cube display options.