Solution needed for below query please.

[rahulhv1]

I have Three tables i.e .

1.Employee Master with fields   : EmpCode., Name , Dept. Machineno,

2.Department Master with fields  : Dept, MachienNO

3.Attendance Records with fields : EmpCode, Date

Result expected as under

[sundarakumar]

But as of data u have emp code d with name def for mc4 under production 1...

Y do u want to show No employee Present in this scenario?

Pls explain..

-Sundar

[sundarakumar]

Please explain the req, how do u want to show the data?

-Sundar

[jagan]

Hi Rahul,

Just load Employee Master and Attendance Record tables, both tables should join by EmpCode.  That's it, now in chart

Dimension:

Department

MachineNo

Date

Expression:

Only(Employee)  if for one machine there are multiple employees then use this

Concat(DISTINCT Employee)

Hope this helps you.

Regards,

Jagan.

[its_anandrjs]

Hi,

Write some thing below

load * Inline

[

empcode, Name, Department, MachineNo

a, abc, Production1, mc1

b, bcd, Production1, mc2

c, cde, Production1, mc3

d, def, Production1, mc4

e, efg, Production2, mc5

f, fgh, Production2, mc6

g, ghi, Production3, mc7

];

Left Join

AttendanceRecord:

load * Inline

[

empcode, Date

a, 01-Jan-14

b, 01-Jan-14

c, 01-Jan-14

d, 02-Jan-14

a, 02-Jan-14

b, 02-Jan-14

c, 02-Jan-14

d, 03-Jan-14

e, 03-Jan-14

];

Left Join

DepartmentMaster:

LOAD * Inline

[

Department., MachineNo

Production1,mc1

Production1,mc2

Production1,mc3

Production1,mc4

Production2,mc5

Production2,mc6

Production3,mc7

];

And in Dimension

Department

MachineNo

Date

in Expression empcode

Hope this helps

Thanks & Regards

[SunilChauhan]

see the attched file

hope this helps

[rahulhv1]

Pls. see the output requird is as under

Selection : Dept : Production1 and data : 01Jan2014.

Output should be as under.

Dept                Machine No.    Date        Empolyee

Production1      mc1               01Jan14    a

Production1      mc2               01Jan14    b

Production1      mc3               01Jan14    c

Production1      mc4               01Jan14   No Eployee Present on the date.

The about output shows that on 01Jan2014 Machineno. MC4 was idle as the empolyee was absent on that date.

[SunilChauhan]

Have you tried my post above