BMT-MD-2049

Error BMT-MD-2049

Getting error BMT-MD-2049 on validating a project. I got this error on a dutch installation, so the error description is in dutch.

BMT-MD-2049 Deze meetwaarde heeft als gegevenstype ‘Character’ en bevat de normale aggregatieregel ‘Sum’. Deze regel wordt niet ondersteund voor dit gegevenstype.
BMT-MD-2050 Deze meetwaarde heeft als gegevenstype ‘Character’ en bevat de semi-additieve aggregatieregel ‘Sum’. Deze regel wordt niet ondersteund voor dit gegevenstype.
Continue reading

Create a Chart with 2 measures and percentage

Used in Cognos 8.4

To achieve this we need to join 2 facts on one time dimension

After publishing the package we create a new report.

Drag in a combination chart

In the series we put 2 measures

After that we create a new data item in the query with the calculation:

[MEASURE2] / [MEASURE1]

We name it PERCENTAGE

After that we drag the PERCENTAGE in the series

chart_2_measures

The following settings are important:

Click on the chart > complete chart is gray

chart_2_measures_2

Click on the right y-axis

chart_2_measures_3

Click on label left of MEASURE1

chart_2_measures_4

Click on label left of MEASURE2

chart_2_measures_5

Click on label left of PERCENTAGE

chart_2_measures_6

Click on the PERCENTAGE

chart_2_measures_7

The result when running the report:

chart_2_measures_8