Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dimension employee. firstname and lastname for employee with sales responsibilities only
could you explain this a bit more? but if I go on what you asked.
you could try and create a table like this
Employee_Table:
Load
FirstName & ' ' & LastName as employee,
FirstName,
LastName
From [\\lib:...]
My guess: You need to figure out how to identify records that match "employee with sales responsibilities only". Then it would be sth. like:
Employee_Table:
LOAD
FirstName & ' ' & LastName as employee,
FirstName,
LastName
FROM
[lib://Server/Folder/Employee.qvd]
(qvd)
WHERE
IsSalesUser; //employee with sales responsibilities only