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

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.