PB in my Data Model

master_student — Fri, 19 Aug 2016 09:05:54 GMT

Hello dear community,

In my data model, I have a dimension that contains a list of offers/services. I put the sncode/tmcode (result of this dimension) in variables to use theme in other tables

For example :

vSN = 1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1066,1067,1068,1069,1070,1071,1072,1074...

vTM = 195,219,221,240,241,247,250,252,264,281,294,295,296,297

An other table in my model contains the activations of those offers/services but the problem that not the exhaustive list of my offers are displayed in this table

SELECT co.co_id,

cs.custcode,

rp.DES as offre ,

co.tmcode,

sn.sncode,

sn.des AS service,

..........

WHERE sn.sncode IN ($(vSN))

AND co.tmcode IN ($(vTM))

.. ;

Here's my data model :

Any idea please?

Thanks

Re: PB in my Data Model

stabben23 — Fri, 19 Aug 2016 10:20:16 GMT

Hi,

if you create a concatenated key With TMCODE&OFFRE&SNCODE&SERVICE as %KeyActivation in both F_Activation_Revenu and D_offre_sans_ressource the Your sync table will be gone.

TMCODE has an Association to another table and should be keep in both table With a New name, like TMCODE as %KeyTMCODE and also in the Associated table..

Another way is to concatenate F_Activation_Revenu and D_offre_sans_ressource With each other.

You can also join D_offre_sans_ressource into F_Activation_Revenu if you need information from D_offre_sans_ressource.

The options is many, you have to know how you shold present data and what data you are intrested in.

topic Re: PB in my Data Model in QlikView

PB in my Data Model

Re: PB in my Data Model