Linking a excel file

[#1]

i have a main data model for which i need to map this attached excel.

Main QVD              

staff name

call date

.....

excel file

Engineer name

roastermonth (which is in different columns)

how do i map this both field to find the no. shifts on each engineer in particular month.

[VishalWaghole]

Hi

if your staff name is equal to engineer name(field from your excel) then

you can link staff name = engineer name.

but for that your both fields should be unique.

Thanks

Vishal.

[michael_maeuser]

You also need to load the excel as a crosstable, just in case you forgot that.

Michael

[#4]

i have done the crosstable and linked the staff name but how to link roster month to my master calender

[michael_maeuser]

i guess you have a "Date" field or s.th. similar in you calendar and you have the problem of a circular reference if you link the excel table to it?

in that case, i think the easiest way is to concatenate your 2 fact tables to one fact table and create a source field.

e.g.

Fact:

load

staff name

call date,

'QVD' as Source

.....

concatenate  (Fact)

Load

Engineer name

roastermonth (which is in different columns),

'Excel' as Source

in your expressions you can seperate the data in set analysis e.g. sum({<Source={'Excel'}>} ..)

[#6]

But need to map roster month to calender to filter the data on month on month wise. to find the engg productivity.