August 10, 2006 at 1:06 am
Greetings,
Hi everyone, i was playing around with the adventure DW database sample already provided by microsoft, I am through till KPI's.
but now the database i am working with is not as simple as the previous one,
Can anyone please shed some light abt how does the AS engine decide upon the Fact Tables and the dimension tables.
and one of the simple KPI's i want is to calculate the no of calls made every month for a particular representative.
which is defined as
Average calls per month = total calls made in a month / total no of working days
Can anyone just give a brief idea as to how to go abt it.
any help is appreciated.
thanks.
August 11, 2006 at 9:00 am
You need to create 2 measures - 1 that sum the calls, 1 that sums the working days
Then make a calculated measure that divides one by the other, but review your data and watch out for nulls.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply