Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

DW Architecture for Special requirement

3 posters

Go down

DW Architecture for Special requirement Empty DW Architecture for Special requirement

Post  virsdnana Fri Jun 25, 2010 6:58 am

Hi,
We have a current DW/BI system that enables BI reporting and holds data for 2 years. We have a requirement from a special user group requesting to extend BI features for their purpose of reporting. However, they require 10years of data, whereas current BI environment holds only 2 as per requirements defined by majority stakeholders.

Please advice on how this scenario should be addressed? Would it make sense to come up with different Arch with Different infrastructural set up? Wouldnt this decentralize the BI? If 10yrs worth data from source is brought into current env, it may hamper the current set up as it is not designed for this.

What should be the approach for such a requirement.


virsdnana

Posts : 1
Join date : 2010-06-25

Back to top Go down

DW Architecture for Special requirement Empty Re: DW Architecture for Special requirement

Post  BoxesAndLines Fri Jun 25, 2010 8:49 am

"Show me the money" should be the words right after yes we can do this. In the end, the cost will become prohibitive and the requirement will be dropped. And yes, you should redesign from the top down if your current architecture is designed to support 2 years of data.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

DW Architecture for Special requirement Empty Re: DW Architecture for Special requirement

Post  ngalemmo Fri Jun 25, 2010 2:03 pm

The question I have is: What is your environment now that requires you to reconsider the architecture because you need to add more data?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

DW Architecture for Special requirement Empty Re: DW Architecture for Special requirement

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum