-
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.…
-
Enable custom sort on Time Range entity members
Hi Team, Currently, the Time entity members doesnt allow custom sorting. In scenarios like we have multiple years and a selector based on year which might have more than 20 members which has both historical and future years, then it will be difficult for users to scroll down to current year and select everytime. If we can…
-
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…
-
Enhancing Generic Entities in Time Range Section
Currently, in the Time Range section of Board, we have the ability to use generic entities to address specific time-related business needs. Some common examples include: YTD (Year-to-Date) Months YTG (Year-to-Go) Months Monthly references such as JAN, FEB, MAR, etc. These generic entities are very useful for standard…
-
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…
-
29th shows values when YCV PY is used
In reference of ticket 142328 I would like Board to display values on the 29th Feb. when the functions YCV and PY are used and values are existing until then in the previous year. Right now this empty. The same also applies for custom time entities where this behavior can be observed. Expectation here: PY YTD should show 1…
-
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…
-
Raise the limit of Custom Time Entities on Time Range
Main Idea: Today, the number of Custom Time Entities is limited to 4. My idea would be to raise this limit number to at least 10. It would be great to have no limit, if possible. The last project I worked on lasted 40 days. If I had a free custom time entity, I could have saved around 3 to 4 days of work, which is a…
-
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
1. Abstract In every Board application, 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. Changing the Time Range during the implementation will require several steps in a specific order. This topic has been already explained in a…
-
Possibility to map selector to only one block
It would be great if you could map a selector (e.g. month) to only one block of a data view. So you could have two e.g. month selector each controlling one block. This would allow a flexible time selection for actuals as well as the comperison period.
-
Extracting list of cubes via Entity analysis
Currently the list of cubes for a particular entity can be extracted through Impact Analysis which only provides the cube name and not other details. If the user is able to extract the list of cubes via Entity Analysis (by clicking on Go to Cubes), it will provide details such as Group name, Data Type, no. of Versions and…
-
Week Description
Does anyone know if there's a way to get Week to have a description which shows the first day of the week instead of the Week number?
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…