Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zang
Starting Member
14 Posts |
 Posted - 2009-04-29 : 12:01:31
|
| Sales Cube: Showing the new clients quantity I have a Sales Cube with conventional measures of sales, discounts, product quantity, etc. But now I need add this measure: productivity of new clients.I show bellow an example of what I need: January February New Sales New Sales Client ClientSalesman 2 123,12 3 20,12Smith 1 133,20 0 30,00Brown 0 2,30 2 40,00Peters 5 50,49 4 10,00Fact Table Example:TimeIdProductQuantityAmountSalesManEvery client has the creation date in the Client Table not in a fact table.How can I built this new measure “New Clients” in my cube?:Hope to be clear.Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-29 : 13:50:15
|
| whats the definition of New Clients? |
 |
|
|
zang
Starting Member
14 Posts |
Posted - 2009-04-29 : 14:43:01
|
| Sorry, If I wasn’t clear.I’ll try to explain betterThe company need to know how many clients are created in a period of time, also how many clients are created for each Salesman in a period of time, this information helps to the company to have a measure of productivity.New Clients are those in what the admission date belongs to the some period of time.Example:Client Client Admission DateA 05-01-2009B 06-01-2009C 01-01-2009D 30-01-2009 E 05-02-2009F 04-02-2009For January of 2009 the numbers of new clients added to the company were 4For February of 2009 the numbers of new clients added to the company were 3Hope to be much clearThanks Ariel |
|
|
|
|
|
|
|
|
Sales Cube: Showing the new clients quantity