FISCAL YEAR END CLOSE - BEST PRACTICES

[R4958]

Hello everyone
I am curious, what is everyone doing at the close of fiscal year to protect the cubes from being overwritten? I know there is an option to lock at the element level for fy and that would impact all cubes using that element. Supposed you did not want to lock every cube in that fiscal year. Do you have cubes that do not impact the financials that you want to leave those open for other purposes. Are you creating cube rules to target/lock a specific fiscal year? Thank you to everyone in advance for sharing your best practices.

[Wim Gielis]

You would just lock the year element, hence for all cubes involved. The year is over and will not be touched again, in none of the cubes.

That being said, we often have different Year dimensions, like Stg_Year for staging cubes, Rpt_Year for reporting cubes, etc.

[R4958]

You would just lock the year element, hence for all cubes involved. The year is over and will not be touched again, in none of the cubes.

That being said, we often have different Year dimensions, like Stg_Year for staging cubes, Rpt_Year for reporting cubes, etc.

Hello, yes we do have some month dimensions for specific cubes but not years. Having different year dimensions would allow for more flexibility if we ever wanted to lock the year of a single cube. Thank you for your response.

[Adam]

Here are some good readings that will help you build what you need:

https://www.wimgielis.com/tm1_cellchange_EN.htm

https://www.ibm.com/docs/en/planning-an ... ty-overlay

[R4958]

Here are some good readings that will help you build what you need:

https://www.wimgielis.com/tm1_cellchange_EN.htm

https://www.ibm.com/docs/en/planning-an ... ty-overlay

Adam, thank you very much for these helpful sites. I will definitely start using them and reading the blog. I really appreciate the resources!