Skip to Content
0
Former Member
Dec 14, 2009 at 08:33 PM

Rearchitecting a dataflow??

11 Views

Hi All,

I have a dataflow that extracts data from ECC using 0FI_GL_4 and sends it to diffrent yearly cubes via a DSO. Each year has a diffrent cube e.g. 2007 2008 2009 and so on with the same technical aspects. A start routine filters the data from the DSO and pushes to the right cube. The problem is that, it is creating severe maintenance issues since we have to create a new yearly cube every year , change the appropriate codes, test them and promote to production. In production, we have total 5 cubes averaging 10 million records per year. We do not have a heavy traffic to access these cubes while reporting since two users run reports using a Multiprovider to get their monthly reports. Our goal is to consolidate the data into one cube and build aggregates or partition as feasible so that we can get rid of yearly maintenance.. What is the best way to achive this goal. Your answer will help us develop a sustainable solution for this issue. Thank you for your help in advance.

-A