Re: Multiple Server Reporting

Hi Peter,

Thanks for the clarification always there has been a debate whether or not
to move the data around.Looks like unless we do that no way we can get
efficient reports Let me try the DW.

/
S

"Peter Nolan" wrote:

> Hi S,
> the generic question is
> 'I have distributed data in operational systems, how do I perform
> consolidated reporting?'
>
> and the generic answer is:
>
> 'bring the data together and integrate it via ODS/DW style processing
> system depending on what your needs are. Then, if the data needs to be
> re-distributed from the centralised data store back out to various
> areas then do that.'
>
> You will almost certainly find that even though the systems are the
> same the data in it will be different and will not 'automatically' line
> up unless someone forced the user community to use some set of data
> standards which almost never happens.
>
> However, with todays line speeds and tools like RS presenting data in
> web browsers the need for distributring that data back out has
> dramatically reduced. I rarely re-distribute the data back out to so
> called 'data marts'...I have been an advocate of 'if the data is
> valuable and important it is worth centralising and managing it
> properly' for over 20 years now... ;-).....I have seen many people talk
> about 'fetch the data from the operational system when it is needed'
> come and go.....many are still coming along and selling that as 'the
> way to do reporting and analysis'......the folks who go that way
> generally regret it very much and end up migrating to an ODS/DW style
> solution sooner or later....especially as volumes increase...
>
> Best Regards
>
> Peter Nolan
> www.peternolan.com
>
>
.

Loading