sql server - can I use a view as fact table

I know that in terms of processing data into the cube it is no big deal, but does this make sense from the relational warehousing side?


thanks

It all depends on the view. If it is simply a different representation of an existing fact (such as calculating derived measures) sure, there is usually little or no impact on performance. If the view performs significant transformation, such a joins, use of windowing functions, etc, there may be significant performance impacts.