master dimension

[bf7684f]

any idea for creating a master dimension with this description:

Employee.[First Name] " " Employee. [Last name] for employees with sales responsibilities only.

thanks

[Anil_Babu_Samineni]

Please explain as much you can instead of business statement. 

[Lisa_P]

I agree with Anil, we don't have enough information to guide you.

How can you determine employees with Sales responsibilities ? From team ? From JobTitle or perhaps they have sales booked against them, please explain more.

Also this would be best done in the load script if possible.

[bf7684f]

sorry it just I'm over stressed,

Last Name	First Name	Title
Rock	Bob	Sales Representative
Presley	Erik	President
Carsson	Rob	Sales Executive
Callins	Joan	Sales Manager
Hendrix	Ingrid	Sales Representative
Skoglund	Lennart	Sales Representative
Borgus	Bjorn	Sales Representative
Shine	Leif	Sales Coordinator
Lang	Jess	Sales Representative
Lawson	David	Product Manager
Cleaves	John	Product Manager
Takako	Miro	Product Manager
Protzmann	Binh	Product Manager
Sandu	Cezar	Systems Manager
Crawford	Judy	Systems Manager
Kregler	Mario	Systems Manager
Stevenson	Sven	Storeman
Baumel	Ira	Storeman
Wesenlund	Rolf	Storeman
Lindquist	Ann	Storeman
Clouseau	Jacques	Storeman
Tessel	Jerry	Network Manager
Applegate	John	Network Manager
Salvatori	Marcus	Storeman
Gupta	Sunil	Storeman
Ärlig	Östen	Account Manager
Park	Bob	Account Manager
Kent	Andrew	Account Manager
Cheng	Joe	Account Manager
Alpan	Kaya	Account Manager
Tyson	Michelle	Account Manager
Gucci	Ricardo	Account Manager
Cioazzi	Steve	Operator/Clerk
Krogh	Zannie	Operator/Clerk
Lanza	Luke	Operator/Clerk
Ashkenaz	Mike	Account Manager
Song	Yifu	Account Manager

Im not sure how to do the master dimension.

I need to create the dimension which shows the:

Employee.[First Name] " " Employee. [Last name] for employees with sales responsibilities only.

thank you

[Lisa_P]

As I mentioned, this is best done in the load script.

I recommend that you combine First Name and Last Name into one field.

In your Employees table 

.... Employee.[First Name]& " " &Employee. [Last name] as EmpName,

...

The loading a new table using a resident load

SalesPeople:

Load EmployeeID,
         EmpName as SalesName 
Resident Employees where Title like "Sales Representative";

[Anil_Babu_Samineni]

Probably with Qualify statement?

Qualify *;

Employee:

Load "Last Name", "First Name", Title From ....;

UnQualify *;