OLAP for Excel

J

jmenche

Does anybody know of an OLAP-esque tool that would be a little more robust
than Pivottables? The limitations of Pivottables that I am trying to
overcome are getting %'s within subtotals as well as the way Pivottables
calculate custom formulas. Pivottables assume a SUM function in formulas.
 
F

Flamikey

You can download for free the Microsoft Excel Add-In for SQL Server
Analysis Services from Microsoft. You will need to have access t
Analysis Services on your server to be able to build your data cubes.
The Add-In will allow you to interact efficiently with the cubes vi
Excel
 
Top