How to make the report ?

[suvechha_b]

Hi All ,

How to join the two report ?

The 'Supplementary' needs to be added in the Customer field with log fees -5981844.

Chart 1.

Sample Model attached.

[rupamjyotidas · Accepted solution]

why not concatenate your Fact table and Supplementary table keeping the fields name same for common fiel

like Cust should be Customer in both table and provision should be Logistics_fee

[vishsaggi]

You have synthetic keys in your model. You have product_key as your key field that joins with other tables.

Can you try like renaming your product code in supplementary table like below and re run your script.

SELECT

      [period_key]   

   ,'Supplementary' as Cust

//      ,'Supplementary Customer' AS [Customer Code Name]

  ,[Product Code] AS Suppl_product_code

......

FROM ..... ;

[balabhaskarqlik]

Can you try like this:

TableA:

Load Brand,

     ProductCode,

     Product,

     Customer,

     LogFees;

Concatenate

TableB:

Load

     Cust as Customer,

     Provision as LogFees;