I've been working with the Analysis API functions for a while now, and I've started adding my ideas for enhancements to the SCN Idea Place.
If you haven't visited the Idea Place for SAP BusinessObjects Analysis edition for Microsoft Office, you can find the page here:
There are several ideas that are worth voting for - Vote and add comments now and hopefully we can get these enhancements implemented.
Here are 2 that I've just added..
Make API calls that can return arrays, always return 2 dimensional arrays
Allow SAPGetCellInfo to accept a multi-cell range, and return multiple cell info arrays
And here are some others that I like...
API to trigger Prompts for Workbook
Extend SAPListOfVariables to return technical IDs also