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?
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 |