Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Lis2002
Contributor
Contributor

Dimension

dimension employee. firstname and lastname for employee with sales responsibilities only

Labels (1)
2 Replies
MartW
Partner - Specialist
Partner - Specialist

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:...]
steeefan
Luminary
Luminary

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