HELP** Measure is not showing real value...

[danielep]

I have a measure in Cognos 8 Transformer that should bring the result of the fild in a table. But as it joins with the fact table it brings the number of records in fact table, instead of bringing the real value of the field.

Example:

Table 1
Id_cr   Name    Qtde
1   Xisttt   1
2   Xzzzzz    2
3   aaaaaa    1   

Fact table
Id_cr   Value
1         100
1   10
1   20

The Measure in Cube should bring for Xisttt the measure = 1. It is bringing 3 because it is taking the count of fact table.

Please, can someone help me?

[nybble]

If you make these separate queries then everything will work properly. The Id_cr field is used as the Source value for the categories, so in both queries it can locate the category for the corresponding measure value.

When you join them you end up with this, which causes your problem:

Id_cr	Name	Qtde	Value
1	Xisttt	1	100
1	Xisttt	1	10
1	Xisttt	1	20
2	Xzzzzz	2	null
3	aaaaa	1	null