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