Hi All,

I have a Sales Analysis OLAP system where the sales transaction is in
different currency while the analysis must be in local currency.
Since the exchange rate fluctuate from time to time, I don't want to update
fact table every time the rate changes, that is why I decide to use VIEW as
fact table.

Does any body know about performance drawbacks consideration of using View
as fact table ?

Thank you for your help,
Krist

The obvious draw back will be time during processing
time, since the lookup for resolving the fact data is
accessed acrossed multiple tables at runtime,

However with todays processing power at hand should not
see serious performance issues whilst processing, other
areas of concern possibly could be when you try to drill
through to underlining data

All the regards in the world