I\'m looking for a sample on开发者_如何转开发 how to expose an olap cube as an odata feed so it can be consumed by powerpivot. I do not want to provide direct access to the cube.
I\'m trying to execute a sql query through powerpivot and I get the following error \"Unable to convert a value to the data type requested for table (massive hex string) column (name)\"
I want to use Power Pivot for one of my Presentation Engine Applicaiton for Transactional Data. Following are the questions for which I am looking for an answer.
So I\'ve run into an interesting problem. I need to specify a custom WHERE clause in a PowerPivot query. I must change it based on external conditions. I would like to edit the file and save a copy. A
Is there anyway to get a shared dataset to simply dump it\'s contents in an Atom or OData feed that can then be consumed somew开发者_运维知识库here else?In our scenario we want to build just the datas
I want to publish an SQL Server database, for testing purposes AdventureWorksDW, 开发者_如何学JAVAthe data warehouse sample database that provides Microsoft. I created a new \"WCF Data Service\" proje
I apologize in advance as this question is quite vague. About a month ago, I stumbled across a blog post featuring some information about a project within Microsoft Research relating to the following
I\'m playing around with OData with PowerPivot and I would like to know can I relate multiple OData services together?
I have a MySQL DB on hostmonster.com and I am trying import data in excel powerpivot, but having hard time connecting to it.
Before I give a description of the problem, here is the list of technologies I am using - Excel 2010, PowerPivot Add-in, Win 7, Macros - VBA