Convert PivotTable to PerformancePoint Planning Matrix
I spotted a 'Convert to PerformancePoint Matrix' menu option on the context menu
of an Excel PivotTable recently.
I'd not noticed it before - it is documented within the PPS Excel Add-In help but only once, and subtly at that. I'm glad to report, on first impressions, it appears to do a fairly decent job.
It's a one-way process that cannot be undone and it creates a 'User defined' MDX style matrix. You are therefore limited to making subsequent edits using the Report Properties window but suffice to say it's a handly little feature that I'll no doubt use more and more now I've found it.