Re: Datawarehouse Architecture

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 02/26/04

  • Next message: Belinda: "Re: SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data" 
    Date: Thu, 26 Feb 2004 07:12:07 -0500

    Just to add to Yuan's post, there are some good articles here on design
    concepts, process vs. departmental, etc.

    http://199.239.255.16/html/articles.html 

    -- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Aaron Relph" <x@x.com> wrote in message
news:OmYvGKu%23DHA.3452@TK2MSFTNGP11.phx.gbl...
> Thanks for your response, As an example:
>
> I have a dimension with a large number of members (4 million) there are 5
> member properties for each member which is a customer. If users want to
see
> a list of customers via cube (i.e. the leaf level) then the performance
will
> be very slow. If however I expose the data in the staging area and let the
> users report off the relational tables then I can put indexes on those
> tables to get better performance for reporting..
>
>
> ""Yuan Shao"" <v-yshao@online.microsoft.com> wrote in message
> news:eqowHns%23DHA.744@cpmsftngxa06.phx.gbl...
> > Hi Aaron,
> >
> > Thanks for your post. According to your description, I am not quite
clear
> > what your problem is. Do you mean that you plan to implement
datawarehouse
> > for the insurance industry? Can you please describe it in detail? In the
> > meantime, I found the following articles for your reference.
> >
> > The Challenge of Access to Analytic Information in the Insurance
Industry
> > http://www.datawarehouse.com/iknowledge/whitepapers/CID3914.pdf
> >
> > http://www.wipro.co.in/whitepaper/bus_int_insurance.pdf
> >
> > I am looking forward to hearing from you soon.
> > Regards,
> >
> > Michael Shao
> > Microsoft Online Partner Support
> > Get Secure! - www.microsoft.com/security
> > This posting is provided "as is" with no warranties and confers no
rights.
> >
>
>
  • Next message: Belinda: "Re: SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data"

    Relevant Pages

    • Re: Is Powerpoint still a single instance app?
      ... PROCESSENTRY32 has a cntUsage member that is supposed to return the "Number ... MODULEENTRY32 has a member GlblcntUsage which returns the "Global usage ... Module32Next APIs. ... My model is the following two articles in the MSDN library. ...
      (microsoft.public.powerpoint)
    • Re: Question for evolutionists - Most ducked/dodged thing by creationists?
      ... Thank you for the low level of guidance to good articles. ... Become a member of a good library. ...
      (talk.origins)
    • Re: IEEE Explore
      ... I have actively used the IEEE Member Digital Library for several years. ... articles a month. ... I've downloaded articles from societies and transactions outside my ...
      (comp.dsp)
    • Computers -- an essential tool for philatelists
      ... The latest issue of the award winning "The Compulatelist" has been sent to the Philatelic Computing Study Group (PCSG) members. ... The 20 page issue has articles on: ... For more information on becoming a member, visit the group Web site at http://www.pcsg.org. ...
      (rec.collecting.stamps.discuss)
    Loading