Hi,

I have some calculated members in my cube which uses the Excel
Quartile function. The calculated members return the data just fine if
I give a MDX query in the MDX Sample application - but it returns null
when I give it in my own code which uses takes the query and uses
ADOMD to get the data from the cube. What could I be doing wrong? I
believe the MDX Sample Application is written using ADOMD - so there
is no reason why it should not work with ADOMD. Should I post my code
here?

Any pointers please ...

Thanks in advance

Regards

Vani Murarka

Are the MDX Sample App and custom app run on the same PC?


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote ...
Yes, they are running on the same PC.

Regards

Vani

One thing I would like to clarify -

In my custom app, I am using ADOMD.NET not ADOMD. Also I am using the
AdomdDataAdapter and putting the result into a DataSet - instead of
using the CellSet. Would this make a difference? I noticed that the
MDX Sample App is a VB app that uses ADOMD and cellset.

Regards

Vani

As a further followup -
Instead of using ADOMD.NET, I even tried with the OleDBDataAdapter -
but here too I get a null if I try to get a calculated member that
uses an Excel function - other calculated members and measures return
data fine.

:-(

:-(

:-(

Vani

Ok. Got the solution. It was calling the "Access denied attempting to
launch a DCOM Server using DefaultLaunchPermssion. " for the user
ASPNET in the Event Log. This user needs to be given permission for
Microsoft Excel as per the following link:

http://support.microsoft.com/default...b;en-us;290398

and it will work fine.

Regards

Vani

Thanks for sharing the solution - I haven't yet used ADOMD.NET, so this
may be useful down the road ...


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!