I want to use WEEK as the base member of BPC TIME dimension

[Former Member]

Dear all experts

I want to use week as the base member of BPC 10.1  TIME dimension.

I wanna set up a account period(1 year )  by 52  week the base member.

For example: 2015.week1, 2015.week2.....

For the PERIOD property, there are only 12 values(JAN~DEC), how should I define the PERIOD property

for each week member?

Regads

[damovand]

Hello,

I don't know what your business requirements are but I have seen this done by creating two hierarchies.  One hierarchy is driven by the standard month as the base levels and the second hierarchy is driven by weeks.  However, if you do use this method you still have to ensure that the TIMEID values are correct in both hierarchies.

Best Regards,

Leila

[former_member186338]

You mean - having base members - days in common between two hierarchies?

Vadim

[damovand]

Hi Vadim,

The lowest level I have seen done is Week.  The challenge is when a week extends from the end of one month to the beginning of another month which then changes the TIMEID.  I'm afraid I don't remember the details but the customer had to have two periods in the week hierarchy for such weeks with two different IDs and TIMEIDs to reflect the correct month.

There may be other ways to work it out, but this is what I remember seeing recently.

Best Regards,

Leila

[former_member186338]

In this case at the end of practically each month the customer has the week split between 2 months...

Vadim

[damovand]

Hi Vadim,

That is correct, that is what I saw in that particular implementation.

Regards,

Leila

[former_member5472]

Hi,

Please check the screen shot. It may be helpful.

Prat

[former_member186338]

Hi Naoko,

What about months - you don't want to use months at all? Weeks are not compatible with months...

Vadim

[Former Member]

Vadim Kalinin による書き込み:

Hi Naoko,

What about months - you don't want to use months at all? Weeks are not compatible with months... 

Vadim

Hi Vadim

Thank you for your help.

I wanna use MONTH  and　WEEK,and  set up the bottom member by WEEK.

Then make  the  TIME  dimension hierarchy　 by month , quarter , halfyear, year....

Please　advise the relationship of WEEK and MONTH .

Best regards.

[former_member186338]

Sorry, but there is no relationship between month and week! There is no relationship even between year and week

Vadim

P.S. For sure you can create artificial months and years but I am not sure it will be OK for you...

[Former Member]

It depends how your Fiscal period and Fiscal year are defined (assuming you plan on those and not Calendar month and year).

If Fiscal period and Fiscal year are defined in terms of full weeks, then you should be fine.

If weeks can be split between periods and years then you have to get an agreement with business how to count amounts in last/first week of the period/year.

[Former Member]

Hi,

maybe use period 1 for the first 4 weeks and so on. some period will have 5 weeks.

Andy

[Former Member]

Hi,Andy

Thank you for your help.

You mean like this?

ID		Period
2015.01	(January week 1st)	JAN
2015.01	(January week 2st)	FEB
2015.01	(January week 3st)	MAR
….
2015.02	(Febrary week 1st)	JAN
2015.02	(Febrary week 2st)	FEB

Best regards .