Topic
No replies
Naresh Patel
Naresh Patel
1 Post
ACCEPTED ANSWER

Pinned topic Cognos Data Manager Fact Build With Dimension Lookup

‏2013-07-24T13:08:24Z |

Hi,

I have fact build with one source which has 2 columns country code and sales target. I have added dimension lookup from where I have to get the country key in the fact delivery by matching country code from source to country code in dimension lookup.

Fact build failed with [Unmatched DimTable] error and does not load any data.

Data Source
----------------
COUNTRY_CODE
SALES_TARGET

Dim_Lookup
------------------
COUNTRY_KEY
COUNTRY_CODE

FACT TABLE (Expected Output)
------------------------------------------
COUNTRY_KEY
SALES_TARGET

Please reply if someone has idea about this. I need complete steps to perform this task.

Thanks in advance.

Regards,
Naresh