I have a Fact table which contains 100,000 records
and it has two measures
Response Counter has the value 1 or 0
Total Count has the value 1.
In Analysis manager I build the cube with these two
measures with the aggregate function sum on the measures
column.
When I browse the data I see records count same for
both the measures, which is correct for ResponseCounter
but not for Total Count.

Any ideas why it is behaving this way.

Please help!!!

Please check whether
1) the Database Column selected for "Total" measure is "Total Count"
2) the Column "Total Count" has got no NULL / Blank values and has '1' for
all the records

cheers,
Sanka


"Usha" wrote: