powerpivot

Analysis Services with excel as front end - is it possible to get the nicer UI that powerpivot provides.

I have been looking into PowerPivot and concluded that for "self service BI" and ahoc buidling of cubes it has its uses. In particular I like the enhanced UI that you get from using PowerPivot rather than just using a PivotTable hooked up to an analysis services datasource. However it seems that hooking up PowerPivot to an existing anal...

Display powerpivot in asp.net page without sharepoint?

Hi, as per the subject line I was thinking it would be possible to just grab a powerpivot exhibit, save/render it as an image of some sort and put it on a webpage. Has anyone had any success doing this? If it isn't 'out of the box' type functionality I'd be happy to look at some hacks like invoking excel via C# and trying to snap an im...

How to calculate number of rows in a 1-to-many relationship in PowerPivot

I'm trying to do what I thought was a relatively simple calculation between 2 tables I have in the new PowerPivot add-on for Excel 2010. My 2 tables loaded at setup as follows: Table 1: FooID, BarID, Name Table 2: BarID, Date There is a 1 to many relationship between Table 1 and 2. I want to add a calculated column to Table 1 that j...

Combining multiple datasets in PowerPivot

Essentially what I want to do is to create an interactive dashboard using slicers in Excel 2010 PowerPivot. I have 3 different data sets from a sql database which share "dimensions." Incoming Orders Sales Order Backlog - essentially what products are currently in production and waiting to ship or invoice Invoiced Sales Each data...

Any way to hide Slicer Values in Excel 2010

I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For example, they are faded in color for 2010 if you have no values in 2010. Is there some setting where I can hide them altogether? If I have sales in 2007, 2009, and 2010; but not 2008 can the slicer list omit 2...

Microsoft Excel Power Pivot - how to add data to an existing power pivot table

Hi, I'm looking for a way to load more recent data as date x in Power Pivot and link/add them to an existing table. Background: The user downloads data from a datafeed and saves them in Excel Power Pivot. The data will be deleted from the server afterwards. In the next step, new data must be added to the existing table in Power Pivot...