cancel
Showing results for 
Search instead for 
Did you mean: 

how to create measures for month-to-month comparison and YTD

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

What is your data source?

Former Member
0 Kudos

Teradata 12.0

Edited by: Arjun_Kushwaha on Dec 30, 2010 12:10 PM