Has any one got any experience developing a data warehouse for financial
accounting? I'm talking, P&L, balance sheets and stuff. If you do kindly let
me know how you went about modelling your facts and dimensions from legacy
sources.

Regards

Mabs

What type of decision support systems are your legacy databases running on?
Relational, network, hierarchy, file?

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"Mabs" <ch3cking@MSN.COM> wrote in message
news2494B2B-936E-4678-9726-3DEE2D38BF2D@microsoft.com...
> Has any one got any experience developing a data warehouse for financial
> accounting? I'm talking, P&L, balance sheets and stuff. If you do kindly
> let me know how you went about modelling your facts and dimensions from
> legacy sources.
>
> Regards
>
> Mabs

On Jan 26, 4:02*pm, "Mabs" <ch3ck...@MSN.COM> wrote:
> Has any one got any experience developing a data warehouse for financial
> accounting? I'm talking, P&L, balance sheets and stuff. If you do kindly let
> me know how you went about modelling your facts and dimensions from legacy
> sources.
>
> Regards
>
> Mabs

Mabs,

more than depending on data sources, dw modeling depends on analysis
requirements.
Usually there is a parent-child hierarchy for accounts, and many times
there is the need for balance reclassification.
We developed a model which allows to create multiple account
hierarchies without duplicating data. This is an evolution of the
Multiple Hierarchies pattern I described in my Many-to-Many Revolution
paper (http://www.sqlbi.eu/manytomany.aspx) and we will publish it in
the future.
However, you can start to model a single hierarchy without
reclassification in the usual way (using the star schema approach in
the relational model, then moving to SSAS 2005 to get parent-child
hierarchies features).

Marco Russo
http://www.sqlbi.eu
http://sqlblog.com/blogs/marco_russo

If I were you, I would get a hold of a tool that lets you immediately
navigate and analyze your data source within a simple dimensional model,
play around with it and realize what exactly you can/want extract from your
data and then proceed to design the data warehouse.

I use SiSense Prism to do this... (http://www.sisense.com)

"Mabs" <ch3cking@MSN.COM> wrote in message
news2494B2B-936E-4678-9726-3DEE2D38BF2D@microsoft.com...
> Has any one got any experience developing a data warehouse for financial
> accounting? I'm talking, P&L, balance sheets and stuff. If you do kindly
> let me know how you went about modelling your facts and dimensions from
> legacy sources.
>
> Regards
>
> Mabs

Excellent !


"Elad" <eladooosh```hotmail```com> a écrit dans le message de groupe de
discussion : ey$SJmMeIHA.4728@TK2MSFTNGP03.phx.gbl...
> If I were you, I would get a hold of a tool that lets you immediately
> navigate and analyze your data source within a simple dimensional model,
> play around with it and realize what exactly you can/want extract from
> your data and then proceed to design the data warehouse.
>
> I use SiSense Prism to do this... (http://www.sisense.com)
>
> "Mabs" <ch3cking@MSN.COM> wrote in message
> news2494B2B-936E-4678-9726-3DEE2D38BF2D@microsoft.com...
>> Has any one got any experience developing a data warehouse for financial
>> accounting? I'm talking, P&L, balance sheets and stuff. If you do kindly
>> let me know how you went about modelling your facts and dimensions from
>> legacy sources.
>>
>> Regards
>>
>> Mabs
>
>
>