EXCEL 2010: Cannot access Analysis Services of SQL 2000

Error "...Unable to locate database server..."
Solution:
Install pivot table service (PTSFULL) from service pack 4 of SQL 2000

Note:
only work with Excel 32-bit version
source: Ole db provider 64 bits for SSAS 2000

Accumulated Average explained

For example, if I have a set of data like this:

5, 10, 15, 20 -

Then, I would want to get Accumulated Average of this set as

5, 7.5, 10, 12.5

Where
1st data is 5, as 5 is the only number so far.
2nd data is 7.5, as (5+10) / 2
3rd data is 10 as (5+10+15)/3
4td data is 12.5 as (5+10+15+20)/4

Source:
www.devexpress.com/Support/Center/p/Q242748.aspx

Filter(s) not visible at Criteria bar

The filter(s) is defined as Local criteria (criteria that is "hardcoded" to the analysis definition yet not visible/changeable to user)

How to edit "Local criteria"?
- Switch to "Define" mode
- Right-click > Functions > Local criteria
- Click criteria in question
- Change value or select Remove criteria

Alternate software & sample analysis

http://demo.qlikview.com/

Configure BA Server as Registered, not Trial

Run BA_Targit\Autorun.exe from installation/setup files
Select 'Servers' menu
Click 'Configure Business Analytics Advanced'
Point to folder where finsql.exe along with FIN.flf exist

If someday ANTserver service won't start, just re-run above procedure.