Setting time range and time entity relationships
Once a year, I plan a task to extend the time range by one year.
I tried extending it by a year, which resulted in unexpected changes to the time entity relationships.
In the example below, the number of child entities Month for FY=2023 should remain 12, but has become 3.
Before the time change
After the time change
I have two questions.
- Is it common for time entity relationships to break after changing the time range in Board?
- What is the best practice for fixing time entity relationships? My current idea is to extract the time entity tree before the time range change in a CSV (using a procedure), and then import the CSV with one year's worth added (also a procedure).
Accepted Answer
-
Hi @MSugiyama ,
first of all, it's fairly uncommon that relationships in the time range get corrupted when just adding a future year. In your case, I would assume part of the cause being the relationship between FY and Month—but, that's just an assumption. You might want to unload the database after applying the desired changes and sometimes it might be neccessary to restart the Board service, as well.
Have a look at our Best Practices regarding the time range.
https://community.board.com/discussion/16407/how-to-define-and-manage-the-time-rangeThe idea of extracting and re-loading the time tree using procedures points in the correct direction.
Kind regards,
Helmut0
Answers
-
Thank you for your reply.
I understand that it is rare for the relationship of time entities to go wrong due to a change in the time range. I suspect that this error occurred because the 半期(half-year) entity was created originally.
Since manually correcting the relationship is likely to lead to human error, I will think about whether there is an easy way to correct it using a procedure. I will also contact Board support about this problem.
Thank you.
0 -
Hi @MSugiyama ,
you can always create the correct relationship if you're using a correctly defined relationship in the file you load - this will "repair" the relationships.
The easiest way to do that would be to extract the time tree, examine and correct the extracted data and then reload it. Once you've done the correction to your file you can set up a procedure to extract the (then correctly defined) relationships and reimport them—this can even be done on a daily basis without causing any harm.
Kind regards,
Helmut0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP