topic Direct Discovery vs Meta Data in QlikView

Direct Discovery vs Meta Data

rajuamet — Mon, 27 Jun 2016 11:16:15 GMT

Hi Techies,

I know when old records are updated in database user selection will query and aggregate the updated values. But when new records are inserted in database whether these inserted records will be read without a reload ? Because without a reload metadata of that field is not updated, right ? So logically Direct Query can not read newly inserted rows without a reload ? It can read only updated rows without reload ? Please someone clarify. Thanks.

Regards,

Rangaraju.

Re: Direct Discovery vs Meta Data

Digvijay_Singh — Tue, 28 Jun 2016 05:08:26 GMT

Dimension fields-

I think Dimension fields will need reload to get the updated and new records. This is what mentioned in the manual -

Note:

When DIMENSION fields are used in List boxes, the data values displayed in the List boxes are not

updated with direct queries. The Direct Discovery fields' data is updated only by reloading.

Measure fields -

This is what QV ref. manual says -

MEASURE fields, on the other hand, are recognized on a "meta level." MEASURE fields are not loaded in

memory (they do not appear in the Table View).The purpose is to allow aggregations of the data in MEASURE

fields to take place in the database rather than in memory.

When measure fields are not loaded in Qlikview document/RAM then it should be able to use the newly added records in the source database without any reload. BUT if new columns are added in the source then script update and reload is needed otherwise direct queries mentioned in the script won't use the newly added columns.

Re: Direct Discovery vs Meta Data

rajuamet — Wed, 29 Jun 2016 04:50:03 GMT

Hi Digvijay Singh,

Thanks for the input. Yesterday I experimented myself. What I came to know is, if I update existing record in sql, it is reflected in qlik app without a reload. But if I insert new record, it is not reflected in app without a reload.

Now I am more confused from your reply, because my inserted row had new dimension. It might also be the case it is not reflected in the app. Now let me try again by inserting a new record with existing Dimension and let you know.

Re: Direct Discovery vs Meta Data

rajuamet — Wed, 29 Jun 2016 14:58:31 GMT

Hi Digvijay Singh,

You are absolutely correct. Inserting new record with existing Dimension is reflected without a reload. Thanks.