-
How to overcome the challenges of a Weekly Fiscal Calendar
1. Abstract Managing a Weekly Fiscal Calendar presents a recurring challenge for organizations operating with 52- and 53-week Fiscal Years. The presence of an additional week disrupts like-for-like (LFL) comparisons, distorts year-over-year variance analysis, and complicates budgeting, forecasting, and reporting processes.…
-
Level300_Module 303: Step "Adjust Planning Data Model Procedures", Actual Months are wrong
Hi, I have an issue in this section. I have set the FCST 3+9 as the data entry version. And now I am in the step above. In the Forecast group I shall add a step after 15 as below I would assume that Actual months and period <>0 should be three as FCST 3+9 is defined, but I always get nine. This is the same issue why I have…
-
Level300_Module 303: Step "Adjust Planning Data Model Procedures", Actual Months are wrong
Hi, I have an issue in this section. I have set the FCST 3+9 as the data entry version. And now I am in the step above. In the Forecast group I shall add a step after 15 as below I would assume that Actual months and period <>0 should be three as FCST 3+9 is defined, but I always get nine. This is the same issue why I have…
-
Level300_Module 303: Step "Adjust Planning Data Model Procedures", Actual Months are wrong
Hi, I have an issue in this section. I have set the FCST 3+9 as the data entry version. And now I am in the step above. In the Forecast group I shall add a step after 15 as below I would assume that Actual months and period <>0 should be three as FCST 3+9 is defined, but I always get nine. This is the same issue why I have…
-
How to set up a 4-4-5 calendar
*NEW—includes video demonstration. Build Along with Board Follow along as we provide a demonstration to further illustrate the basic principles shared here. Please note the recorded example may vary slightly from the written example, providing an alternative approach to the 4-4-5 calendar.…
-
Time relationship for custom time range entity
Hi there, I need a new Half Year entity, parent of Quarter (Q1+Q2 = H1; Q3+Q4 = H2) and child of Year. Entity members have been populated for all years in my system. However, when I try to fix the relationship as Day > Month > Quarter > Half Year > Year, this new entity doesn't get captured in the correct way. If I drag…
-
Why does the "Previous Year" time function still return current year data?
I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or…
-
End Date on a Day (as Start Date)
In the rows I have the day entity. In column 1 the possibility to enter a number of new hires and in column 2 the end date for the new hires. The date on which I enter the new hires should represent the start date. In a procedure, the number of new hires should now be written to the days from the start date to the end…
-
Dataflow common mistakes and best practices Pt. 2
1. Abstract The dataflow is the main action to perform calculations between cubes, it is used in all the processes of the application, therefore it is very important to know how to set up a dataflow in the best possible way, to obtain the correct results with the best performances. 2. Context In this article, we will first…
-
Dynamically manage calendar settings
1. Abstract In many cases, we will need certain mappings in our Calendar to define specific time frames for reporting and planning purposes. Some of those may be custom time dimensions and others might be created by mapping the standard calendar to specific periods. All those mappings have to be kept up-to-date. That can…
-
Level 300, Module 304: How do I upload the data into the data reader? #Level300: Building a Planning
FIND HOW MANY HOURS: How many hours did you made to accomplish module 302 in Level 300
-
How to calculate % of current month using Days cube
Hi Board Team, I would like to calculate how many percent is passed for the current month. Basically, use today's date divides no.of.days in the current month. For example, today is 9th Oct. I would like to achieve the calculation of 9 divides 31, which is 29%. Can I use BOARD default time entity Day and Month to achieve…
-
How can I flag all periods between 2 dates?
Hi, I need to load some discount values from a table in SQL but the table does not have a month column. Instead, we have 2 separate columns; for Start Date and End Date. In normal circumstances, I would just take the last value from each of these dates and subtract the two lists, leaving me with the period between being…
-
Update pre-existing time entities
I have two questions - Can we update the description of pre-existing time entities using data reader?For example - In BOARD ,day entity has code = 20240919 and description = 19/09/2024.I want to replace description with "Thursday". My Fiscal Year starts from July.I want my weeks counting to start from July instead of…
-
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…
-
How to define and manage the time range
1. Abstract In Board, the definition of the time range becomes very important because it guides the data that will be loaded and made visible to the end user. When setting the time interval, there are some considerations to bear in mind to avoid running into unpleasant situations during the development phase, where the…
-
Extend the Time Range
Hi, I need to Extend the To Year and I tried to follow the How to Guide: How to change the Time range in GCR https://community.board.com/discussion/17913/how-to-change-the-time-range-in-gcr But I don't have or I don't know where to find the different elements you quote in the text: the location where this file should be…
-
How to manage the leap year in comparative analysis
1. Abstract In an application life cycle it is not unusual to come across leap year management, moreover when comparative analysis are put in place. Accurate handling of leap years ensures data consistency across different timeframes, preventing discrepancies when comparing results from different years or performing…
-
How to change the Time range in GCR/FCR
*** The entire approach described in this article is valid also for FCR application. FCR represents the natural evolution of GCR - rebuilt on the latest Board Platform with an optimized UX/UI to provide access to the latest financial consolidation capabilities. *** 1. Abstract In every Board application, the definition of…