BPC Time Dimension - 13 periods NOT Calendar

[Former Member]

My client reports 13 periods in a year (4 weekly).

Quarter two contains 4 periods (periods 4, 5, 6, 7).

I was reading a post about how to set this up properly using the UserTimeId property. They had a situation where they needed to put their 13th period in Qtr 4, and they discussed using this property, but the answer didn't go into exactly what settings to put in the UserTimeid property.

Could someone explain how to set this up in BPC so that it calculates properly - my system is a YearToDate system (not periodic),

regards

scott Farrington

[Former Member]

Can anyone help with this please,

thanks

Scott Farrington

[esjewett]

Hi Scott,

Have you tried just putting these 4 periods in Quarter 2 on your time dimension hierarchy? I believe the hierarchy (not the properties) is what drives QTD reporting, so theoretically that should work. I have not tried your specific scenario however as it is a fairly uncommon setup.

If that doesn't work and you can explain exactly what kind of issues you are seeing, then it might be easier for others to come up with helpful solutions.

Thanks,

Ethan