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,

Question on cube granularity again

Hi, all,

Again, I wonder is it a good idea to design the granularity level of the cube as the same as in its underlying relational database e.g the most detailed level as it is in its fact table and its dimension table.

I am looking forward to hearing from you for any advices.

Thanks a lot in advance.

With best regards,

Yours sincerely,

It really depends on your requirements. I would say you probably should make the granularities the same unless it's going to cause serious performance problems with the processing and/or querying of your cube - it just means you have all the data your users might want available. Changing the granularity of your cube once you've gone into production would also be a bit messy.

Chris

|||

Hi, Chris,

Thanks a lot for your advices. Very good point.

With best regards,

Yours sincerely,