Author Topic: multiple fact table not supported by dimension  (Read 608 times)

Offline atmane

  • Associate
  • **
  • Join Date: Sep 2017
  • Posts: 1
  • Forum Citizenship: +0/-0
multiple fact table not supported by dimension
« 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
hope you have a goud day