BIDS - Excel Pivot Table - Data Cube - What - if analysis

Milton

Guest

Posts: n/a

5th Aug 2009

Hi, I have created a cube with Business Intelligence Development Studio –
MSSQL 2005, and I provide to the customer Excels with Pivot Tables (Excel
2007 - connected to the data cube) as an end user tool. Now the customer
wants to perform What-If analysis to those Pivot Tables. I try to use the
feature from excel, meaning the what-if analysis under the tab ‘Data’ and is
not working. I will appreciate any information that can help me. Thank you.

« 2 level sorting | Sum only selected cells »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table accessing data from OLAP cube	Neha Sachdeva	Microsoft Excel Worksheet Functions	0	23rd Feb 2010 04:33 PM
Expanding/Collapse pivot table rows from Analysis Server cube	Gunder	Microsoft Excel Misc	0	8th Mar 2008 12:45 PM
suppress warning and locate cube in a pivot table from olap cube	Tewari	Microsoft Excel Misc	0	28th Mar 2007 06:54 AM
cube analysis add -in for excel and local cube	swetha	Microsoft Excel Discussion	0	28th Jul 2006 09:25 PM
connecting a pivot table to a data cube in VBA	=?Utf-8?B?U3RldmU=?=	Microsoft Excel Programming	0	25th Nov 2004 04:09 AM