If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Metrics Designer 8.3 - Qualifiers

Started by morne12, 19 Jan 2009 09:29:10 AM

Previous topic - Next topic

morne12

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é

morne12

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é