PB in my Data Model

[master_student]

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

[stabben23]

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.