Updating realtime (denormalized) DW from transactional replication

[Database Administrator]

Hello!

At the moment were running reports off a reportserver which is a copy of the
production DB.

In order to improve reporting, I would like to use a denormalized DW instead
of the production-copy.

Updating this DW could easily be done using SSIS every night, but our users
really appreciate the (almost) realtime-updates which the transaction
replication offers us.

Does anyone have an elegant solution to this ? (Im not sure creating
triggers for all tables accounts for an "elegant" solution

David