COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: atmane on 13 Sep 2017 06:19:16 AM

Title: multiple fact table not supported by dimension
Post by: atmane on 13 Sep 2017 06:19:16 AM
hi everybody
i actually working on a solution that have two fact tables, and i need to add one more fact table
so the etl work fine
i add my new table to the pack in ibm framework manager , and i make relations between my fact table and other tables "tables that are used for dimensions in transformer"
i make some tests in framework manager the relations are goud
when i make a cube i cant find aggregation between dimensions and my fact table it give the total sum of my fact table.
when i search suported  data sources in dimension i realize that the my table facet is not supported by thee dimensions
i dont know how to make that relation in transformer......
any help
sincerely
hope you have a goud day