Problem with synthetic Keys

[#1]

Hi Guys,

I have three tables T1,T2,T3

In all the above tables I have a month and day fields( Field names are different)

I am loading the data and I have two list boxes for Month and Day and the fields selected in the boxes are from T1)

Also i having two bar charts which will have data from T2 and T3

Now I have selected month and Day from list boxes which will be reflecting in the current selection box also

But the bar chart values are not filering based on the selection (Because the fields for month and Day is different in these tables)

I am having some issues in using the synthetic key.So I am not supposed to use it.

Without synthetic key how it is possible to change the chart values depending on the selection?

Anybody have any idea?

Please share...

Thanks

Praveena

[Miguel_Angel_Baeyens]

Hello Praveena,

If two tables must be affected by the same date selection, they may be joined or concatenated. Try renaming in both tables day and month fields and concatenate both tables, the chart should work now with one listbox for the day and another for the month.

Table1:
LOAD ID,
     DayField AS Day,
     MonthField AS Month,
     Amount
FROM Table1.Source;
CONCATENATE LOAD ID2,
     FieldDay AS Day,
     FieldMonth AS Month,
     Sales
FROM Table2.Source;

The next step is to create a fact table and link it to a master calendar, but let's see if this works.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica