https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45541#M5214 In our implementation we have chosen to design our data marts using star schemas. One reason was that in EG, the "Get values..." would in most cases access a dimension table, which in most cases are much smaller in size than the fact table (or a corresponding demoralized table).<BR /> <BR /> /Linus Thu, 18 Jun 2009 14:17:27 GMT LinusH 2009-06-18T14:17:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45539#M5212 Is there some option to persuade the Query Filter to limit its scan of the underlying data when I press the "Get Values" button ?<BR /> <BR /> At present the scan takes far too long because the table is large<BR /> <BR /> HTH<BR /> <BR /> PeterC Wed, 17 Jun 2009 13:07:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45539#M5212 Peter_C 2009-06-17T13:07:35Z https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45540#M5213 Peter,<BR /> <BR /> EG 4.1 with the latest hotfixes and EG 4.2 both get the values in batches. You should see a "Get Values" button that, when clicked, retrieves the first batch of values. If there are more values to retrieve, you'll see a "More Values" button to click so you can get the next batch.<BR /> <BR /> Are you seeing that interaction and if so, are you finding that the operation still takes a long time?<BR /> <BR /> Chris Thu, 18 Jun 2009 13:35:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45540#M5213 ChrisHemedinger 2009-06-18T13:35:40Z https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45541#M5214 In our implementation we have chosen to design our data marts using star schemas. One reason was that in EG, the "Get values..." would in most cases access a dimension table, which in most cases are much smaller in size than the fact table (or a corresponding demoralized table).<BR /> <BR /> /Linus Thu, 18 Jun 2009 14:17:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45541#M5214 LinusH 2009-06-18T14:17:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45542#M5215 many thanks Chris,<BR /> <BR /> we don't see that "batches" button, <BR /> so, <BR /> we'll give that hotfix a try.<BR /> <BR /> appreciate the support<BR /> <BR /> PeterC Thu, 18 Jun 2009 17:39:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/quot-get-values-quot-table-scan/m-p/45542#M5215 Peter_C 2009-06-18T17:39:22Z