-
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,…
-
Entity Definition - Concatenation or not
1. Abstract In complex applications, we often face a situation where we have too many dimensions structuring the cubes. In such cases, it is necessary to evaluate the impacts on the usability of the application, and to measure the risks on the overall performance. In case of performance issues, one of the possible…
-
The Backup Mentality
1. Abstract Each Board environment should foresee an appropriate backup policy for the existing Data Models, should it be a development, sandbox or production environment. Such backup policy must always be present and it should be developed on top of the standard backup policies implemented by the cloud team for disaster…
-
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…