-
DOWNLOAD NOW! Take on Board 2025–2026 Report: Your Feedback in Action
Those that have met me can appreciate how ensuring that Board remains customer-driven is so important to me and everything we do. To that end it gives me great pleasure to announce the second edition of Take on Board – Customer Experience Report 2025–2026 which is, yet again, — built entirely on: your feedback. Over the…
-
How to version a hierarchy
1. Abstract Sometimes as well as holding the current state of a hierarchy, it might be necessary to also retain a history of not just entity values but relationships as well. 2. Context While it’s common to retain history of relationships in Board by breaking hierarchies into standalone entities and using matrices to track…
-
How to map entities using text cubes
1. Abstract Users often need to configure mapping cubes across applications in Board to maintain one to one relationships to entities. However, when these entities contain a large number of members, manually selecting or updating mappings directly in the mapping cube becomes cumbersome and error-prone. This article…
-
Default relationships (missing parent)
"Default button" to fix the missing relationships: is it a one-time solution for members to "missing parent" at the moment or can you use that function as a default automatically for new members that have a missing parent?
-
Level 200, Module 204 - Relationships (missing parent)
I have followed the instructions in the tutorial and have some issues with the relationships in my data model. I have already found one problem related to my data readers, where some rows were discarded because either the "code width", "desc width" or "item number", which we had to set up when creating the entities, was…
-
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…
-
Error that table borders are not displayed
Hello. I have a problem where some of the borders on the left side of the data view I am creating are not visible. Please see the attached image for details. The left border is not displayed for industries colored in yellow. In another data view with the same template and settings, the borders are displayed correctly. For…
-
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
-
Historicisation of relationships
1. Abstract In Board, hierarchies are without time reference as standard. This simplifies data modeling in many cases. In some cases, however, it is necessary to map relationships between different nodes in a time-dependent manner and thus to historicize the values. There are different methods for this, which are to be…
-
Matrix relationship SQL not working 🤔
Hello dear community, I want to do a matrix relationship via SQL datareader (same as explained in the resources below) : https://community.board.com/discussion/16889/how-to-manage-mapping-data-entry Here is a screen of the ETL : The result is an empty cube with no discard and "1" as a validated record Thank you in advance…
-
How to use Nexel to update relationships
1. Abstract Relationships are a fundamental component of all multidimensional data models in Board, allowing creators and users alike to easily aggregate and analyze data within an application. This ease of use on the front-end is highly dependent on the proper maintenance of hierarchies in the back-end. 2. Context…
-
How to use Unbalanced Hierarchy
1. Abstract A common requirement when structuring hierarchies in Board is to create an unbalanced hierarchy, Board facilitates this with a dedicated feature “Unbalanced Hierarchies”. 2. Context Unbalanced hierarchies can be a very useful addition to a Board solution; however, how to define and maintain them requires some…
-
Relationship changes logs
Hi Board Expects. Quick question: does any of the log files provide the details of relationship changes between entity members? A DB log shows the entity names and shows the record that the relationship was modified. Can we see anywhere the members of child and parent entities? Eg. we have Item → Item Category…
-
How to make multiple relationships coexist in the same hierarchy
1. Abstract Establishing and managing relationships effectively is crucial for the optimal performance of a Board implementation. In numerous instances, it becomes necessary to accommodate multiple relationships within the same hierarchy. Therefore, it is vital to make informed decisions when constructing the…
-
Dummy entity elements for budgeting purposes
1. Abstract In planning processes, sometimes it is necessary to manage new occurrences that don’t exist in real life yet, which means creating provisional elements in the master data that will serve only for planning purposes. 2. Context Creating provisional elements in master data for planning purposes means creating new…
-
Normalization in High Concurrency
1. Abstract In Board’s multi-dimensional database, relationships are a core component of a data model configuration. Properly designing and maintaining relationships is essential for a well-functioning solution. Missing relationships, both direct or indirect, can lead to inaccurate or incorrect conclusions or behaviors.…
-
Default setting for Relationship
Hello, When there's a parent missing to a child, the Default button becomes visible. But if there are no errors, you won't see the button. Is it possible to set the Default mapping for each Relationship from somewhere else, even if there's nothing missing at the moment? Thank you
-
How to structure cubes with slow moving hierarchy
1. Abstract A common challenge in a Board Application is to fulfill the request of tracking changes in hierarchies, which by definition are the current snapshot of a relationship. This article describes how to keep track of the historical situation using a cube and dedicated entities. 2. Context Since a hierarchy in Board…
-
Missing child in Relationships
Hi, I'm trying to create a dashboard on ESG Net Zero Emission. I've picked only a particular worksheet (1a_RM_&_pack_calc_1.csv) and created entities and built relationships for them, but after running the Data Reader, I'm getting an error on Missing Child in relationships. Thanks & Regards, Kranthikumar Goli.
-
Level 200 Module 204 Material and Material Group Empty
I'm trying to complete step 7 and following the instruction to manually set up relationships between Material and Material Group but both seem to be empty. Have I missed a step where data was meant to be uploaded? I've scrolled through a few times but can't see anything I've missed. most likely just my mistake though. Any…