Desktop productivity for business analysts and programmers

"get values" table scan

Reply
Valued Guide
Posts: 2,174

"get values" table scan

Is there some option to persuade the Query Filter to limit its scan of the underlying data when I press the "Get Values" button ?

At present the scan takes far too long because the table is large

HTH

PeterC
Community Manager
Posts: 2,693

Re: "get values" table scan

Peter,

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.

Are you seeing that interaction and if so, are you finding that the operation still takes a long time?

Chris
Valued Guide
Posts: 2,174

Re: "get values" table scan

many thanks Chris,

we don't see that "batches" button,
so,
we'll give that hotfix a try.

appreciate the support

PeterC
Esteemed Advisor
Posts: 5,198

Re: "get values" table scan

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).

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 104 views
  • 0 likes
  • 3 in conversation