2 Replies Latest reply: Sep 4, 2012 5:29 AM by 902009 RSS

    "Reverse Star schema" to star schema

    939165
      Hey

      This is my first post and I´m working with OWB for abou 4 Months now.

      My problem:

      I am working with a cube but instead of a real star schema I always get a model like this:

      a fact in the fact table of my cube matches to multiple records in the dimensions. (1 to n)

      The cube itself is ok and even the results but on the database site I want to implement a real star schema.
      Is there any way to remodel the dimensions or the cube or tables so that i an get a star schema.

      I read about bridge tables to solve this problem, but I´m not sure they can help me.

      Anyone an idea?

      Thanks Mario