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



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

Main Menu

multiple fact table not supported by dimension

Started by atmane, 13 Sep 2017 06:19:16 AM

Previous topic - Next topic


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
hope you have a goud day