DW Architecture for Special requirement
3 posters
Page 1 of 1
DW Architecture for Special requirement
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.
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
Re: DW Architecture for Special requirement
"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- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: DW Architecture for Special requirement
The question I have is: What is your environment now that requires you to reconsider the architecture because you need to add more data?
Similar topics
» Measures as special dimension table
» Modelling a special kind of dimension
» Special Higher-Level Rows in Dimension
» Report requirement has the following ...
» Requirement gathering
» Modelling a special kind of dimension
» Special Higher-Level Rows in Dimension
» Report requirement has the following ...
» Requirement gathering
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum