topic Re: How to debug missing data in QlikView

How to debug missing data

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlikview community,

I succeeded so far to build a Fact table (a Star model) and I added dimensions Tables.

The next step is to connect this fact table to other tables containing data needed for comparison to mesures in the fact table (in a chart diagram).

To connect these tables to the fact table I used composite keys.

Results:

1. I am getting good results from the first table named (BUDGETPROD). The Key I defined for this table is:

CODUSN&'-'&ANNEE&'-'&CODPROD AS BudgetCodeKey, (The same in the fact table)

2. I am getting missing data (for some months) for the second table (BUDGETPRODM) . The key I defined for this table is:

CODUSN&'-'&ANNEE&'-'&CODPROD&'-'&MOIS AS BudgetMoisCodeKey. (The same in the fact table)

Some monthly (defined by MOIS) budget values are missing for a given product defined by CODPROD and a factory code CODUSN in a given year ANNEE.

My Question is there is a debug method that I can use to find the error?

Thank you,

Abdallah

Re: How to debug missing data

YoussefBelloum — Wed, 23 May 2018 09:19:43 GMT

Hi,

your first fact table and your Budget tables are connected to each others with composite key, right ?

Do your fact-tables share the same dimension tables? can you do a "CTRL + T" and make a screen shot?

Re: How to debug missing data

absekrafi — Wed, 23 May 2018 09:45:45 GMT

Hi Youssef,

Yes my fact tables share the same dimension tables but the Table TableDeFait is connecting all the tables.

Please see the screen print.

Kind regards,

Abdallah

Re: How to debug missing data

Frank_Hartmann — Wed, 23 May 2018 09:47:33 GMT

Please upload a small sample qvw which demonstrates your problem

Re: How to debug missing data

absekrafi — Wed, 23 May 2018 10:12:34 GMT

An other picture my be it is clearer

Re: How to debug missing data

YoussefBelloum — Wed, 23 May 2018 10:20:06 GMT

i think you should rethink on how you should create and link your budget tables..

for me, you can create one single physical budget table (that includes your different Budget tables, which have different granularities) and concatenate it on your Fact-table.