on 12-22-2010 4:26 AM
Following is the report layout, all measures that needs to be displayed
10P10-- 10P9-- Var-- Var %-- 09P10-- 2010-- 2009-- Var-- Var %-- 09FY
We are using Period instead of month as year could start from June, then 10P1 will be june, not jan
10P10 - current month --> 2010 Period (Month) 10
10P9 - previous month
var - diff of above two
var % - diff in %
09P10 - previous year current month
2010 - YTD
2009 - YTD
09FY - 2009 year
We are having transaction(L1, L2, L3, L4) dimension in hierarchy, like this
-
10P10----
10P9
L1 -
L2 -
L3 -- -
L4
1 -- 1.1 -- 1.1.1 -- 1.1.1.1
-
1.2 -- 1.2.1 -- 1.2.1.1
we have 1 fact & 3 dim tables
fact - trn_id, date_id, loc_id, sales, volume
date dim - date_id, date, month, qtr, yr
trn - trn_id, L1, L2, L3, L4
loc - loc_d, country, state, city
What is your data source?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.