I'm totally new on computing on SSAS, and quite new to SSAS in general.
I'd like to get some index like
"tell me the total of contracts started in that year, having status different than '101', divided by the total of contracts ended in the previous year, for each agency (row) and for years from 2010 to 2012 (columns)".
The cube features dimensions StartDate, EndDate, Agencies, and Status.
Facts are contracts each one with datestart, dateend, amount, agent ID, and status.
I'm totally blank: where should I start from? KPIs? Aggregations? Computations?
Any help (even the minimal one) will be greatly appreciated.
Thanks in advance