I thought i'd put rogether a quick post on Cube customisation, as this is something that I am constantly asked about. Now I am not an MDX expert at all, but there are some useful results you get from some pretty simple MDX expressions. Firstly, custom measures are done in the OLAP Cube Database Management section of the Project Web App Server Settings page. Hightlight the cube you want to customise and then click Configure. Once in this section you need to scroll down to the bottom and decide which cube you want to add the measure to in the OLAP database. Generally in most scenarios, the Portfolio Analyser cube is the best target, depending on the data you wish to interrogate. Once the cube is selected, click Insert. S-Curves OK, so you've got a decent OLAP report (in excel, PerformancePoint Services or the like) showing data by month, but you been asked for a nice S-curve report showing Baseline, Work and Actual Work on a cumulative curve. As with all useful things,
sharing the love