powerpivot
Any sample on how to expose a olap cube as oData so it can be used using powerpivot?
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.[详细]
2023-04-12 11:57 分类:问答Powerpivot sql query fails - Unable to convert a value to the data type requested for table column
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)\"[详细]
2023-03-26 10:02 分类:问答Power Pivot in C# & Columnar Database
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.[详细]
2023-03-16 22:39 分类:问答Changing connection data in PowerPivot file
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[详细]
2023-03-02 20:02 分类:问答Get OData or Atom Service feed for SSRS 2008 R2 Shared Dataset
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[详细]
2023-02-25 10:03 分类:问答Large datasets published with OData WCF Data Services and Excel PowerPivot
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[详细]
2023-02-20 10:17 分类:问答Real-time Reporting via Web Services (PowerPivot Futures)
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[详细]
2023-02-11 17:48 分类:问答PowerPivot Multiple OData Services Related
I\'m playing around with OData with PowerPivot and I would like to know can I relate multiple OData services together?[详细]
2023-01-31 07:01 分类:问答Accessing MySQL DB into Excel 2010 powerpivot
I have a MySQL DB on hostmonster.com and I am trying import data in excel powerpivot, but having hard time connecting to it.[详细]
2023-01-24 16:53 分类:问答How to Print a Chart in Excel 2010 for every value of a Slicer?
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[详细]
2023-01-24 05:26 分类:问答