This project is read-only.

MDX query not working: "Object reference not set to an instance of an object."

Jan 11, 2011 at 8:51 AM

 

I am trying to get ORAYLIS BI.Quality to work. SQL queries work fine, but MDX gives the following error:

SELECT FROM [Dekking] CELL PROPERTIES VALUE;

Message:

Object reference not set to an instance of an object.

I can run the MDX statement in SQL Server Management Studio without a problem.

This is the connectionstring

:
 

<Connection>
<Name>APM_APK MDX</Name>
<ConnectionString>
Provider=MSOLAP;
Data Source=RDWXXXXXX;
Integrated Security=SSPI;
Connect Timeout=5;
Initial Catalog=XXX;
</ConnectionString>
</Connection>

 

ValidateConnections works okay.

This is my testcase:

<QueryTest>
<Query table="t1" connectionref="APM_APK MDX" include="Erik.mdx" />
</QueryTest>

Jan 11, 2011 at 6:19 PM

Hi,

the issue you described above could be reconstructed on the AdventureWorks database. To workaround that issue you should select the default measure on the 0-axis.

Best regards,
Adrian

Jan 14, 2011 at 2:35 PM

Hi Adrian,

you are absolutely right. I tried the simplest MDX I could think of, but it turns out that it is too simple.

Thanks, it is working fine now!

Bertus