Op Thu, 7 Oct 2004 17:29:43 -0700 Pratibha Agrawal wrote:

I don't know for sure:
Is the field where you calculate the SUM a float/integer or a string? When
it's a string field it doesn't work (I assume)


--
Rob
7-10-2004 14:28:22
legedoos _ at _ hotmail _ dot _ com

Get hold of the query that AS is firing against your data warehouse when you
process your cube. You can get this by logging it from AS or running Profiler
aganist your data warehouse (I'm making the assumption that you're DW is on
SQL Server).

Then just run that query against your DW and see what it returns. If it
returns zero rows then you've found the problem.

Regards
Jamie Thomson
http://www.conchango.com


"LegeDoos" wrote:

My fact table contains the data but all the measure shows null values. My
measure contains either sum or count of some field in fact table. but it
doesn't return the value in fact returs the null.
where is the problem.
Thanks

when i run query on As it returns null value and no row..
but when i process the cube and traces it in profiles.. that returns some
value for all the measures in fact table...
it means data is there in fact table but it doesn't sum up that to show me
when i give the query. Till y'day it was giving me proper ans.

"Jamie Thomson" <jamie.thomson (AT) donotspam (DOT) conchango.com> wrote

AS2K treats all nulls as zeros. It has no special semantics for handling
nulls -- AS2K5 will.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Pratibha Agrawal" <pratibha (AT) intraactionsoftware (DOT) com> wrote