topic Re: Direct Query - Refresh Dimensions in QlikView

Direct Query - Refresh Dimensions

Thu, 04 Aug 2016 12:27:40 GMT

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!

Re: Direct Query - Refresh Dimensions

sunny_talwar — Thu, 04 Aug 2016 14:35:21 GMT

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

Re: Direct Query - Refresh Dimensions

maheshkuttappa — Thu, 04 Aug 2016 14:52:25 GMT

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

Re: Direct Query - Refresh Dimensions

dtronel — Thu, 04 Aug 2016 15:26:34 GMT

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

Rgds