(1) Simple MDX expressions: Create a number of ratios for key business metrics (eg. ‘profit margin %’) to be browsed alongside a base cube measure such as ‘profit $’.

(2) Simple MDX named (measure) sets: Create in BIDS/SSAS Calculations tab, and include newly-created MDX ratio expressions in set list ABOVE the non-ratio measures

. In PPS Analytic Chart, drop this named set into (non-stacked) Analytic Chart’s ‘Series’ area. In PPS Dashboard, create a ‘Member Select’ filter using the same named set. Allows end-users to select from a list of measures to display. When user selects a ratio, it automatically establishes a multi-axis chart, with Y-axis (left side) for bar values and Z-axis (right side) for ratio values.

(3) SSAS Time Series Utility Dimension (not so simple, so the code is provided in the document): In addition to popular Time-Utility Dimension expressions such as ‘YTD, Prev Yr, and Rolling X Month Avg’, I’ve added ‘Rolling X Month Avg + 2 Std Dev’ and the same for ‘… - 2 Std Dev’, so that users can perform self-service trend analysis on all cube measures. For a PPS Analytic Chart visualization that’s easy on the eye, of course, I recommend the line chart as default.

Have a look!