9 Replies Latest reply: Jul 25, 2010 6:38 AM by Andreas Buchholz RSS

    Sum of values for different dimension in one dimension

      Hi folks,

      maybe somebody can help me.

      I have two different facts:

      1. Revenue

      2. Presales hours

      Now I want to place both in the same table with a date dimension - to make it simple, let say "year". The problem is, both are related to a date but to different dates. The "Revenue" is linked to "Incoming Order date". The "Presales hours" is linked to "Work time from".

      In my table I want to show how much revenue was made per year and also how much presales hours where booked. I'm totally lost because both don't share the same date dimension.

      Changing the data model is unfortunately not possible. I thought about a loosely coupled calendar but don't know how exactly this can help me.

      So, please give me sime hints.

      Thanks,

      Andreas