-
Pagination for API-Queries
API-Queries are a great way to expose Data to other Board-Systems or third-party-applications. Big Data-Sets could end in Time-Out. It would be helpfull to cut big datasets in smaller pieces with pagination. Please have a look on Pagination on REST API call Procedure step.
-
Sending data between data models.
Hi Board, We have two different data models and we need to sedn data from the one data model to the other and vice versa. Currently what we have tried is the following: Extract the data from data model A, call a procedure in data model B that would import the extract through Azure using a data reader and paste the data…
-
Sparsity
1. Abstract During the creation of a new cube, the question is usually about whether dimensions should be dense or sparse. A cube can store a value for any combination of its dimension’s members: for example, a three-dimensional Cube (e.g. month, product and customer), has a cell for any triplet. If every customer…
-
How to compare 2 different cubes to show an alert?
Hi Community! I am working on figuring out a way to compare two different data entry cubes to show alerts. The goal is to have one DE cube to match the sum of by Month DE cube values, and if the sums don't match the alert or notification will appear. Are there any ideas on how would be best to approach this?
-
How to do multi level allocation
1. Abstract A Multi-Level cost allocation is an important process of any business, it plays a huge role in the decision-making process, and that’s why we must design it in the best possible way. The Multi-Level cost allocation consists of applying a classic allocation but with the possibility that an element can be at the…
-
How to manage mapping Data Entry
1. Abstract In many cases, mappings are used to control processes. Mostly, these are mappings between entities that cannot be implemented in the standard relationships (hierarchies) for various reasons (e.g. they are not n:1 relationships, or the hierarchical trees would become too large to be useful from a performance…
-
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.
-
Integrated technical documentation functions
1. What is your idea? The Idea is, to have the possibility to directly document the application within Board. For example: Entity Comment possibility for each Entity technical name Cubes Naming Convention field / technical name possibility to comment (maybe overall and in addition on Cube Version level) Value explanation…
-
Dataflow common mistakes and best practices
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…
-
Best Practices in Writing Procedures
1. Abstract Most probably every Board application will have procedures to cover interactivity by the user (e.g., navigation), perform calculations (e.g., processing plan data) or run other backend processes like creating a backup. To provide the best maintainability, quality, and robustness, some guidelines should be…
-
Impact Analysis update of information
Good morning, Our team would like to know if there's a method to update the impact analysis information. We have verified some cases where a name of a procedure or a screen is changed manually but this is not reflected in the impact analysis, which still shows the previous name. We believe having seen this for other…
-
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,…
-
Auto Max Item Number
1. Abstract One of the initial steps of the development phase in a project is the creation of entities. The most important property of an Entity is the Max Item Number which needs to be defined carefully, considering the effect it has on the performance of the application. 2. Context One of the entities’ most important…
-
Application Navigation Design
1. Abstract Navigation is "the act of moving between screens of an application to complete tasks". It is about managing the path that the users can follow when using an application and therefore it involves defining the different navigation steps (based on the level of flexibility required) and eventually combining them…
-
Managing high-volume entities
1. Abstract In complex environments, it happens to manage elements with a high volume. In such cases, it is crucial to identify the possible cascading effects on the rest of the model and what measures need to be taken when loading entities with millions of elements and evaluate in advance the possible impact on cubes,…
-
Cube definition insights
1. Abstract Insights on cubes definition and options. 2. Context The following best practices are applicable every time a new cube needs to be created in a data model. 3. Content Some limitations and constraints but also tips and guidelines from best practices and real-life cases. Cube’s dimensions can range from one to…
-
Extract all Cubes – Filter Cubes by Entity
Description In Board it is possible to extract all cubes with procedure step “Extract all cubes”. It would be great to have an option to filter the cubes by entity or list of entities. For example I have a database with 1500 cubes. 600 cubes use the entity Planversion. I like to extract only all cubes with this entity. Use…
-
How to Change the Entity Order
1. Abstract An Entity sort is a parameter set when you create the Entity, which can be updated during the development phase. It may be necessary to evaluate the addition of new members or re-evaluate the order of the elements. In this case, it’s suggested to use a dynamic sorting mechanism based on a Cube and, in other…