etl best practice

Hi
With As there's a lot of ETL.
How much is there with report builder ? I've seen the up-coming versionn
of the erp system Dynamics Ax and it looks as if there is no ETL at all -
they
just build a report model ontop of the production database.
Is this ok ? Give's realtime but is the transaction database structue okay
for building larger reporting solutions ?
/Michael V.I think you need to perform the etl to get to the datasource view state,
then you may want to build an AS 2005 cube, or a report object model or
both. My point is the etl gets you to the intermediary point. ETL may not
be required, but may be waranted for the same reasons we used etl processes
in AS 2000. I'm not familiar with Dynamics Ax.
Steve MunLeeuw
"michael v" <test@.test.com> wrote in message
news:OxB7TjZzGHA.3440@.TK2MSFTNGP06.phx.gbl...
> Hi
> With As there's a lot of ETL.
> How much is there with report builder ? I've seen the up-coming versionn
> of the erp system Dynamics Ax and it looks as if there is no ETL at all -
> they
> just build a report model ontop of the production database.
> Is this ok ? Give's realtime but is the transaction database structue okay
> for building larger reporting solutions ?
> /Michael V.
>