Question on Null values displayed for measure members

Hi, all,

Why I got Null values displayed for my measure members which are originally not null in its underlying relational database engine. Their original values are 0 or 1, but then when I query the OLAP cube data, the values for these measure members are all changed to Null. That's really strange.

Could any of you here have any ideas on what is the cause of this problem?

I am looking forward to hearing from you shortly and thanks a lot in advance.

With best regards,

Yours sincerely,

Hello Helen. Open management studio and run a query like " select topcount 1000 * from MyFactTable"

You can also browse the fact table in the data source view by right clicking it.

I have never seen values of 0 or 1 being interpreted as null in AS2005 unless you have a data source that is not in SQL Server.

Are you using SQL Server as a source or another database vendor?

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your kind attention.

Yes, the data source is on SQL Server database as well. I set this aggregation function of this measure as Count which will count the numbers of being 0 or being 1. Does it have something to do with its aggregation function?

Thanks.

With best regards,

Yours sincerely,