Days in Time Dimension

[dipalpatel]

Hello

I have BPC 10 MS version. In Time Dimension, I have Year, Quarter and Month. I want to add one additional level - Day.

I am able to add Day in Time Dimension and process it successfully. But the TimeID is not properly populated. It is taking next number of Quarter TimeID for that Year. But i want timeid - "20160901" for the Day.

Do i need to do anything specific so that system populates timeid properly?

Thanks in advance

[Former Member · Accepted solution]

Hi Dipal,

I dont understand the need to change the TIMEID property, mainly because it is created by system itself in a format understood by it. We can modify it too....but with proper numbering. Follow below post to change the TIMEID correctly....

Hope this helps...

Regards,

JP

[dipalpatel · Accepted solution]

Hi JP

Thanks for the response. Yesterday,  I have gone through the link you posted.

System creates proper timeid for months. For e.g. if I add 2017 November , it creates 20171100 as timeid.

But when I add day to it, For e.g. 2017 November 1st - it should create timeid of 20171101, but instead it creates timeid like 10000067 which is next number of 2017 Quarter 4.

I tried to change this timeID manually in the dimension, but when I process it, it changes back to original which was created by the system.

Thanks again

Dipal Patel

[dipalpatel · Accepted solution]

Found out the solution.

Need to populate usertimeid column for Days to populate proper timeid. System copies Usertimeid and populates into TimeID Column.

Thanks