Hi All,

I am using Analysis Services 2000 and developing web application for
showing report to user.

I am generating queries at runtime based on user selection of measures
and dimensions.

Query is getting generated fine. I can see the output in MDX sample
application.

I am using OLEDB to get the data.

The problem is I am not getting any negative cell values through oledb.
It is returning DBnull instead of actual negative value.

I construct query with below functions or keys.

1. Non Empty
2. Aggregate
3. Descendant()

Appreciate your help in resolving this.

Regards
Raghu