Hi,

In a cube, we have created a cell action. The action statement as
entered in the cube designer is:
"C:\Program Files\Agilent\DataViewerLite\DataViewerLite.exe -server
sqf4357 -maxrows 1000 -provider MSOLAP.2 -catalog UMTS -cube UMTS " +
"[Measures].[Volume]" + " """ + [END Time].CurrentMember.UniqueName +
""" """ + ...
The statement runs up to 1015 characters.

In the statement we are trying to invoke an executable with several
parameters.
We process the cube and display the data in Analysis Manager. However,
when we right click on any cell in the displayed table, Analysis
Manager crashes. It just vanisihes from the screen.
The same this happens if we right click on a data cell in Crystal
Analysis 10.
Id we delete the action from the cube, we can right-click on the cube
without any problem.

Are we hitting a limit or doing something else wrong, that causes this
problem?

We use MS Analysis Services 2000 with service pack 3.

-Yash

Hi Yash

I cannot repro it with Foodmart, no matter how long the action is. Maybe it
is a problem of DataViewerLite application which crashes ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Yash" <yashgt (AT) yahoo (DOT) com> wrote

I changed the action to be something as simple as "cmd /k dir". It still
doesn't work. Anyway, I am not "invoking" the action when I right-click on a
cell. So Analysis Manager should'nt crash. But it does.
I tried replacing the action with a cube action. This time, AM does not
crash when I right-click on a cell. But it crashes when I right-click on the
corner of the displayed table.
The cube has 47 shared dimensions and 18 measures. The levels total up to
196. The cube uses all the 47 dimensions.
If I remove one dimension from the cube, and reprocess the cube, I am able
to right-click on a cell and it does'nt crash.
When I right-click a second time, it crashes as before.
I have tried the cube on a machine with a lot of RAM too and the problem
remained. So it is not that something runs out of memory.

Can someone suggest a shotcoming?

Thanks

"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote