greetings,

i have hard time solving this problem:

fact table contains

posting date amount due date


now i need a cube, which for any given date shows sum of amount
with due date reached, and sum of amount which didnt reach due date yet.

for example:

fact table
09.01 100 09.10
09.02 200 09.15

cube should show:

date reached not reached
...
09.09 0 300
09.10 0 300
09.11 100 200
09.12 100 200
...
09.16 300 0

i have no luck trying to compare two different time dimensions, or even
coming up with idea how could i make this work

thank you!

Hello QQ,

Hope this helps:

sum(due.currentmember:due.firstsibling,[Measures].[Value])

Jörg



"QQ" wrote:

how exactly do i setup the date dimensions to get the result i need?
i dont think i have any luck trying different combos :/


"=?Utf-8?B?Sm9lcmc=?=" <Joerg (AT) discussions (DOT) microsoft.com> wrote in
news:C51EBA6F-A0AD-4B1C-9786-9AC22CC0DB23 (AT) microsoft (DOT) com: