Sacha finds an interesting "upsizing" feature for Pivot tables.
Now if only it was so easy to convert from Report Wizard to Matrix to Custom MDX to Management Reporter Reporting Services... and back again.
There should be a market for PerformancePoint Planning RDL converters pretty soon...
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.
Convert PivotTable to PerformancePoint Planning Matrix - Sacha Tomey's blog
No comments:
Post a Comment