I have an oracle table that contains my source data.
In this table I have columns for actual, target etc, and a column for qualifier. In this table I have 10 rows, 5 rows for each qualifier.
In metrics designer in the metrics mapping page I drag the appropriate columns to the mapping, including the qualifier name.
When executing the metrics extract and transferring the data into target, it does not create two qualifiers as per my oracle table, it creates one qualifier for the first row in the table, and then sums all the data in the table, instead of splitting it for each qualifier.
How do I map data from a table to a metric type using qualifiers?
Thanks
Morné
I managed to fix this issue.
In Framework manager, make sure that the qualifier ID is an "Identifier" and not a "Fact", else metrics Designer will summarize the data.
Thanks
Morné