Monday, July 18, 2011 7:01 PM
If so, does anyone know where are documents and samples.
Tuesday, July 19, 2011 2:02 AM
Programmatic creation of PowerPivot workbooks is not supported in this release.
- Proposed As Answer by T.K. Anand Tuesday, July 19, 2011 2:02 AM
Tuesday, July 19, 2011 11:58 AM
Thank you for your reply.
Do you mean it will be supported in the final release?
For importing data from table & view, will it support programmatically provision a data filter?
And For importing data from a query, will it support getting data from a stored procedure which requires a parameter now? And in the final release, can this be automated?
From my point view, without these features, the PowerPivot really cannot be called self-service analytical tool for everyone. At the most, it can only be used by professional analyst.
Thursday, July 21, 2011 1:22 PM
For our company, we have a set of data security policy, data availability to a user is defined by a set of user secure policy role. for majority sales folks they only have access to the data of their own business. that is why programmactically filter data by uer login/ user role, it is a must to us in order to let sales folkes to adopt the tool.
And many our existing reports have more than 5 parameters, some of parameter values are impossible to let a non-tech user to fill in the "import from report" window. This is another reason for us need a programmatic creation of powerpivot support.
does anyone know, in final release of the product, willthose features be available?