budget vs sales

[Anonymous]

I have the following design

Budget :

load

"Code Site"&"Code Structure"&Comp&"Date Time" as BudgetId,

    summonth,

    sumyear

;

SQL SELECT "Code Site",

    "Code Structure",

    Comp,

    "Date Time",

    summonth,

    sumyear

FROM QlikDataWarehouse.dbo."V_Budget";

But I didn't get the best result , how to resolve it ?

[Mark_Little]

Hi,

Could you please supply a little more information?

What are the issues you are seeing?

From the above I am assuming the table TempVente is your fact table, ideally for the budget values to be driven by the calendar I would be looking to concatenate the budget table to the fact table.

Mark 

[rubenmarin]

Hi, I would check that the BudgetId values loaded in Budget has a similar value in TempVente tables.

For that I'll create a field BudgetId_Budget in Budget table and a BudgetId_Vente in TempVente tables.

With a table box with BudgetId, BudgetId_Budget and BudgetId_Vente you can check if all columns have a related value or there are something differnt (just guessing but most probably caused by different dates format, maybe one is datetime and the other only date)

[jafari_ervin]

what do you mean you didn't get the best result. Please explain more and send sample document.