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

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

atmane

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