help on time dimension??

[former_member225916]

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

[former_member186498]

Hi Naidu,

I never use week or days but i think your error is on TIMEID, I think it should be
2013.APR_W1  APR_W1 2014.APR 2014 WEEK1 WEEK 20130401
2013.APR_W2  APR_W2 2014.APR 2014 WEEK2 WEEK 20130402
2013.APR_W3  APR_W3 2014.APR 2014 WEEK1 WEEK 20130403
2013.APR_W4  APR_W4 2014.APR 2014 WEEK2 WEEK 20130404
2013.APR_W5  MAY_W1 2014.APR 2014 WEEK2 WEEK 20130501
If you use also the days you should make sure that the TIMEID value of the week is between the TIMEID values of the days.

If not ok and you have 7.5 or higher, can you please share also the ISBEGINNING property?

Kind regards
Roberto

[former_member225916]

Hi Roberto,

If i want to do week wise for FY 2013-14, then should i need to do for remaining(old years(2012,2011)) Years also???

i.e all hierarchies(2011,2012,2013) in Time dimension should be equal??? 

i modified as per your suggestion but still i am not getting data from DB.

in dbo.time table, weeks next level is month(2014 year)  but for remaining years(2012,2011),month next level as month. Pls have look on screen shot.

Thanks and Regards,

Naidu

[Former Member]

Hi Naidu,

I have had problems before when I had different numbers of months for different years in my system (the first year we didn't fully use, so I only set up 3 months instead of 12). The problems went away as soon as I made all years equal (i.e. all now have 12 months).

So maybe try to set up all years equally.

Regards,
Arnold

[Robert_Jan_Bron]

Hello,

All years in the time dimension should have the same amount of levels. So you should set up weeks for all years.

But if you do this for periods where you already have data, what are you going to do with the current data? In all hierarchies, data will be deleted if you create a mamber under a baseleve member becasue data is always stored at baselevel members.

[former_member225916]

Hi Arnold and Robert,

Thanks for responding.

May be from next year, users want day wise also. because i created one custom dimension which contains dates(YYYYMMDD) and weeks.here, one more problem is, my users want to see week level reporting for some account members and for remaining members they dont want.

Thanks and Regards,

Naidu

[former_member186498]

Hi Naidu,

you can put these different filters directly in the reports

(f.e. with =EVCVW(<application>;<TIME>;"CALC=Y")

Kind regards

     Roberto

[Robert_Jan_Bron]

I would advice to create a different model for reporting topics that are reported in a different frequency. So create a model for monthly reportin, weekly reporting and maybe in the futere daily reporting (but think twice before you start daily reporting. And if you stil want it think a third time).