portfolio analyzer: Command Text was not set for the command objec

[dfeigen115]

We're running Project Server 2003. multiple users are receiving the
following popup error "command text was not set for the command object" when
exporting from Portfolio Analyzer to Excel and/or updating (requerying the
OLAP Cube) from an existing spreadsheet. The popup specifies that

Any clues/assistance would be appreciated.
Dan

 

[dfeigen115]

I've seen reference to a deployment guide in another posting related to the
same error, but there was no follow up. Is this referencing an Excel or
Portfolio Analyzer document? The error is not received consistently. Our
Macro security level in excel is "high".

 

[dfeigen115]

some additional info: the problem appears to be related to using the
filtering option within the "row" values. If I select individual entries and
try to export I get the error, if I let it display all row values, the export
works.

 

[Yale-Frost]

We have the same Problem with our Analysis Server.
( When we are accessing an OLAP Cube with EXCEl 2003)
We have a dimension with 3 levels.
We ar not able to display elements of the lowest level.
We get the same error.

But it appears to be a problem with the quantity of elements in the lowest
level.
When we have just 100 elements it works fine, but if there are more entrys
in the lowest level, we get the error.

Any idea?