Thank you for your help. I am having a lot of difficulty getting models to run that have nested fact tables. These fact tables are quite large. I am curious. Do you find applying a filter (such as restricting the date of product purchases
to a certain month) is more effectively done (i.e. less time to process) as a model filter in BIDS or directly in a named query in the data source view.
What has been your technique in setting up models that may have years worth of data?
Thanks in advance,
View Complete Post