Data Model Maintenance

Featuring: Eric Laurin is a Principal Solution Architect and Community Captain In Professional Services, new challenges often uncover practical lessons that can benefit the broader Board Community. The Board Platform offers many powerful capabilities, but some helpful options may not be immediately obvious. In this edition…

1. Abstract Over time, Board applications accumulate large volumes of historical data and obsolete sparse combinations, which can negatively impact cube size, performance, and maintainability. While standard clearing operations are commonly used to enforce data retention policies, they do not physically remove data…

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…

We are looking at all cases where a procedure executed from a screen can fail and stop. We have found what I relate below. ⚠️ Could you, please, point to additional cases? This way they are registered for future consultation by other members of the Community. ⚠️ When a procedure is launched from a screen, it can be with a…

Hello. Currently, I am performing maintenance operations while having clients use capsules created with Board. I would like to take data backups as part of my regular work. As I understand it, the way to take backups in Board is to create a snapshot of the data model by making a copy of the files in a backup directory from…

Hi all, I'm wondering if there is an easy solution to rename the data model name in call procedures in bulk. I've just read the best practice with regards to data model names, and it's to bad that during the implementation of BOARD (years ago) we didn't take this into account. While implementing BOARD, the consultant used…

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…

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…

1. Abstract In the case of an architecture with several data models, the synchronization process may be required to update metadata and data. Defining which data model should be the master and how to set up synchronization is of primary importance. 2. Context In complex and cross-functional applications, having a single…

*NEW - includes video demonstration. 1. Abstract The Entity ‘Max Item Number’ is used to reference data stored in a Cube version. It determines how the data pages are physically stored and influences performance as much as dataflow execution. 2. Context The amount of master data will increase during an application…

1. Abstract Are you allowed to delete Entity items? What should you consider when deleting an Entity? There are different options to make deletions, like Entity extract or reload, or assigning to a dedicated dummy parent. It’s important to understand the best way to do it since both solutions have different effects. 2.…