-
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…
-
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 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 placed (%Conso_Dataset%\Standard_Entities\Tree Month.txt) and the procedures ADM-…
-
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…
-
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…
-
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…
-
How to set up a 4-4-5 calendar
1. Abstract Board offers the possibility to create custom time entities in addition to the standard time entities to customize the calendar to specific business needs. Our goal will be to build a retail calendar based on the scheme of a 4-4-5 quarter, which is a method of managing accounting periods, mainly adopted by some…
-
Custom Time Entities – Generic Month example
1. Abstract Custom time entities are a subset within the time range section in the BOARD database. They are mainly adopted during the application to intercept those time analyses which cannot be implemented with only the standard time function available by default in the BOARD data model. Since they are limited in BOARD,…
-
How to compare the same days of a different year
Hello, I need to create a cartesian chart in order to show how much my company has sold this year and how much last year. The main problem is that we sell more on weekends, so if the first day of the year is satuarday, the year before it was friday, and it's obvious that this year performance is better than the last year's…