Relationship

Unbalanced Hierarchies - Allowing "selection mode" configuration in dataflow and export
Hello everyone, Yes, this is my first post on the community. Following internal advices and multiple external feedbacks I'm sharing this Idea that seems to never been raised. My idea is to allow a developer to configure the default behavior expected on an unbalanced entity selection, only by configurating option mode to…
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…
Entity 'Copy' feature should be made available, apart from the 'Replicate' feature.
Hi, I hope this IDEA finds you all good and helpful. This IDEA concerns a simple feature that is currently not available in the Board application and making this available can help solving many issues related to the Incorrect reports and data. Cause of IDEA: Many users use the 'Replicate' feature, thinking that they are…
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) : 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 for your help
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…
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. It would be ideal if the Default button would be visible at all times, or maybe have an overview window (like the Normalize window), where you could set up the default mapping. In the…
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…
Cross-DataModel analyzer for relationships & entities saturation
In a multi data model environment, it could be useful have some centralized diagnostic functions for a quick control through all data models for some common controls, e.g. 1 Relationships (missing parent) 2 Relationship (missing child) 3 Entities saturation (e.g. that highlight all entities with saturation > 80%, or with…
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.…
Option of restricting elements for selectors
Up to now, for a selector, there was only the possibility to display all elements or only the active elements. However, I had the requirement in many projects that the selectable elements should be restricted depending on other filtering. Reasons could be for example: Elements of entities are no longer valid, but should…
Deleting entity elements made easy
There is already a guide on "How to remove obsolete entity members". However, this process should be much easier. It would be great if entity members can be deleted easily by hand. Especially, in big databases that would be a huge relief because it wouldn't be necessary to reload the entity and cubes. As a bonus, it would…
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.
Extract/Import Trees Unsorted
Hello, I'm sure any admin of BOARD has faced the issue needing to refresh Development Cubes/Entities with new info from Production. I'm sad to say that this process is FAR less straightforward than it would seem. It is very frustrating to always have to follow the steps of : A) Remove all sorting of entities (Production)…
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…
Entity with many levels - suggestions
Hello, We have a new customer that has an Account dimension with nine levels (!). It's an Unbalanced Hierarchy. Before we start to build too many objects depended on the Account entity/entities, we would like to ask this creative Community for input and knowledge sharing. This object(s) should fulfill our need of: -…
Relationship
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…
Relationship - Scanning for Errors
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…

Relationship

Discussion List