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

M

Milton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table using analysis services cube as data source 0
Dealing with a Pivot Table (when I don't want to) 0
Prevent modification of pivot table totals 0
Excel 2007 pivot tables - calculated fields and SSAS cube 3
Does Anyone Have a Excel Writeback Cube Sample? 0
Pivot table access - Connection 2
How edit cell in Pivot Table 1
Cube analysis addin with macro 0

Top