Direct Query - Refresh Dimensions

[#1]

Hello,

I'm trying to build a data visualisation for our production, this should be nearly "real-time" (within a minute) so I want to implement it as direct query.

So far my query doesn't look that bad and I've found a method to refresh the measures, but how can I Qlikview force to reload my dimensions?

My Query looks like this:

DIRECT QUERY

DIMENSION

ORDER.PART

ORDER.DATE

ORDER.NUMBER

MEASURE

ORDER.QUANTITY

STORE.QUANTITY

FROM ORDER

JOIN STORE ON ORDER.PART = STORE.PART

Thanks in Advance!

[sunny_talwar]

I think for capturing new dimension value you will have to refresh the application. AFAIK, direct query won't update the dimensions.

[maheshkuttappa]

Sunny T is correct fields defined under dimension are in-memory and needs refresh get new values

[dtronel]

Hi. You should schedule an automatic reload every minute (hoping table are not 'Big Data') in the Management Console....

Rgds