JonFox (11/8/2011)

PaulB-TheOneAndOnly (11/8/2011)

Any particular reason not to use the actual FACT table as the center point of your datamart? After all related DIM tables are related...

Thanks very much for your input.

There is probably not a lot of changes from each reload of data. But the problem is that it in theory could be, even though...

Thanks for your input,

However, i just had an idea.

Why dont we just do a right outher join on distinct months and year? That would give the running totals as pr....

Yes i guess that works in theory. if you also add a where clause on the totals so we only sum the correct accounts)

But problem is that when postings has...

Due to buisness needs we need to calculate the YTD totals in the view itself. So even though presentation-layer would be the best solution it would not work in this...