Dimensional Modelling

On Jan 26, 4:02 pm, "Mabs" 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
 >> Stay informed about: Dimensional Modelling 

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" wrote in message

> 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
 >> Stay informed about: Dimensional Modelling 

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" wrote in message
>
>> 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
>
>
>
 >> Stay informed about: Dimensional Modelling