Skip to Content
0
May 22, 2013 at 12:59 PM

help on time dimension??

22 Views

Hi All,

i am facing the problem while creating week level members in time dimension.

can anybody suggest me how to create week level members in time dimension???

i want to create for FY 2013-14. please have a look on screen shot and tell me where is the mistake??

If i add week level members in time dimension, i was not getting data from DB.

ID NEWID EVDESCRIPTION PARENTH1 YEAR PERIOD LEVEL TIMEID 2014.TOTAL
2014 TOTAL
2014 TOTAL YEAR 10000030 2014.Q1
2014 Q1 2014.TOTAL 2014 Q1 QUARTER 10000031 2014.Q2
2014 Q2 2014.TOTAL 2014 Q2 QUARTER 10000032 2014.Q3
2014 Q3 2014.TOTAL 2014 Q3 QUARTER 10000033 2014.Q4
2014 Q4 2014.TOTAL 2014 Q4 QUARTER 10000034 2013.APR
2013 APR 2014.Q1 2014 APR MONTH 20130400 2013.MAY
2013 MAY 2014.Q1 2014 MAY MONTH 20130500 2013.JUN
2013 JUN 2014.Q1 2014 JUN MONTH 20130600 2013.JUL
2013 JUL 2014.Q2 2014 JUL MONTH 20130700 2013.AUG
2013 AUG 2014.Q2 2014 AUG MONTH 20130800 2013.SEP
2013 SEP 2014.Q2 2014 SEP MONTH 20130900 2013.OCT
2013 OCT 2014.Q3 2014 OCT MONTH 20131000 2013.NOV
2013 NOV 2014.Q3 2014 NOV MONTH 20131100 2013.DEC
2013 DEC 2014.Q3 2014 DEC MONTH 20131200 2014.JAN
2014 JAN 2014.Q4 2014 JAN MONTH 20140100 2014.FEB
2014 FEB 2014.Q4 2014 FEB MONTH 20140200 2014.MAR
2014 MAR 2014.Q4 2014 MAR MONTH 20140300 2013.APR_W1
APR_W1 2013.APR 2014 WEEK1 WEEK 10000035 2013.APR_W2
APR_W2 2013.APR 2014 WEEK2 WEEK 10000036 2013.APR_W3
APR_W3 2013.APR 2014 WEEK3 WEEK 10000037 2013.APR_W4
APR_W4 2013.APR 2014 WEEK4 WEEK 10000038 2013.MAY_W1
MAY_W1 2013.MAY 2014 WEEK5 WEEK 10000039 2013.MAY_W2
MAY_W2 2013.MAY 2014 WEEK6 WEEK 10000040 2013.MAY_W3
MAY_W3 2013.MAY 2014 WEEK7 WEEK 10000041 2013.MAY_W4
MAY_W4 2013.MAY 2014 WEEK8 WEEK 10000042 2013.MAY_W5
MAY_W5 2013.MAY 2014 WEEK9 WEEK 10000043 2013.JUN_W1
JUN_W1 2013.JUN 2014 WEEK10 WEEK 10000044 2013.JUN_W2
JUN_W2 2013.JUN 2014 WEEK11 WEEK 10000045 2013.JUN_W3
JUN_W3 2013.JUN 2014 WEEK12 WEEK 10000046 2013.JUN_W4
JUN_W4 2013.JUN 2014 WEEK13 WEEK 10000047 2013.JUL_W1
JUL_W1 2013.JUL 2014 WEEK14 WEEK 10000048 2013.JUL_W2
JUL_W2 2013.JUL 2014 WEEK15 WEEK 10000049 2013.JUL_W3
JUL_W3 2013.JUL 2014 WEEK16 WEEK 10000050 2013.JUL_W4
JUL_W4 2013.JUL 2014 WEEK17 WEEK 10000051 2013.AUG_W1
AUG_W1 2013.AUG 2014 WEEK18 WEEK 10000052 2013.AUG_W2
AUG_W2 2013.AUG 2014 WEEK19 WEEK 10000053 2013.AUG_W3
AUG_W3 2013.AUG 2014 WEEK20 WEEK 10000054 2013.AUG_W4
AUG_W4 2013.AUG 2014 WEEK21 WEEK 10000055 2013.AUG_W5
AUG_W5 2013.AUG 2014 WEEK22 WEEK 10000056 2013.SEP_W1
SEP_W1 2013.SEP 2014 WEEK23 WEEK 10000057 2013.SEP_W2
SEP_W2 2013.SEP 2014 WEEK24 WEEK 10000058 2013.SEP_W3
SEP_W3 2013.SEP 2014 WEEK25 WEEK 10000059 2013.SEP_W4
SEP_W4 2013.SEP 2014 WEEK26 WEEK 10000060 2013.OCT_W1
OCT_W1 2013.OCT 2014 WEEK27 WEEK 10000061 2013.OCT_W2
OCT_W2 2013.OCT 2014 WEEK28 WEEK 10000062 2013.OCT_W3
OCT_W3 2013.OCT 2014 WEEK29 WEEK 10000063 2013.OCT_W4
OCT_W4 2013.OCT 2014 WEEK30 WEEK 10000064 2013.NOV_W1
NOV_W1 2013.NOV 2014 WEEK31 WEEK 10000065 2013.NOV_W2
NOV_W2 2013.NOV 2014 WEEK32 WEEK 10000066 2013.NOV_W3
NOV_W3 2013.NOV 2014 WEEK33 WEEK 10000067 2013.NOV_W4
NOV_W4 2013.NOV 2014 WEEK34 WEEK 10000068 2013.NOV_W5
NOV_W5 2013.NOV 2014 WEEK35 WEEK 10000069 2013.DEC_W1
DEC_W1 2013.DEC 2014 WEEK36 WEEK 10000070 2013.DEC_W2
DEC_W2 2013.DEC 2014 WEEK37 WEEK 10000071 2013.DEC_W3
DEC_W3 2013.DEC 2014 WEEK38 WEEK 10000072 2013.DEC_W4
DEC_W4 2013.DEC 2014 WEEK39 WEEK 10000073 2014.JAN_W1
JAN_W1 2014.JAN 2014 WEEK40 WEEK 10000074 2014.JAN_W2
JAN_W2 2014.JAN 2014 WEEK41 WEEK 10000075 2014.JAN_W3
JAN_W3 2014.JAN 2014 WEEK42 WEEK 10000076 2014.JAN_W4
JAN_W4 2014.JAN 2014 WEEK43 WEEK 10000077 2014.JAN_W5
JAN_W5 2014.JAN 2014 WEEK44 WEEK 10000078 2014.FEB_W1
FEB_W1 2014.FEB 2014 WEEK45 WEEK 10000079 2014.FEB_W2
FEB_W2 2014.FEB 2014 WEEK46 WEEK 10000080 2014.FEB_W3
FEB_W3 2014.FEB 2014 WEEK47 WEEK 10000081 2014.FEB_W4
FEB_W4 2014.FEB 2014 WEEK48 WEEK 10000082 2014.MAR_W1
MAR_W1 2014.MAR 2014 WEEK49 WEEK 10000083 2014.MAR_W2
MAR_W2 2014.MAR 2014 WEEK50 WEEK 10000084 2014.MAR_W3
MAR_W3 2014.MAR 2014 WEEK51 WEEK 10000085 2014.MAR_W4
MAR_W4 2014.MAR 2014 WEEK52 WEEK 10000086

Thanks and Regards,

Naidu