Skip to Content
0
Former Member
May 08, 2008 at 01:21 PM

ODS DESIGN:Urgent

13 Views

Hi all,

We need to design a new ODS .But can anyone help me out with a proper solution on how to go about this.Its an Aging Report.We already have the Aging cube.But we need to have detail level data .So , We need to build an ODS.

The Aging Detail is even more complicated because of the different aging dates (aging type) that are used. We will have to work to come up with a good design so drill down queries will work properly with the summary aging queries.

So, the main issue is it is aging on different dates like Posting date,document date .

Can anyone come with good suggestions?Points will be awarded.

Thanks,

Samir