Table Of Contents: Best Practices

Center of Excellence

Welcome to Board Best Practices! Here you will find links to a list of published articles that provide technical guidance on the best ways to use the Board platform and a preview of articles that are in progress.

The table of contents for How-to Guides that provide step-by-step guidance for specific use cases can be found here.

Time Range

• Custom time entities - Generic Month example

Entities and Relationships

• Managing high-volume entities
• Auto Max Item NR
• Set up Relationships
• Data Transformation
• Relationships - scanning for errors
• Entity Definition - Concatenation or not
• Data Load Guidelines
• Historicization of relationships

Cubes

• Cube Definition Insight
• Sparsity
• Temporary cube vs staging cube
• Multiple cubes or measure entity

Procedures

• Dataflow common mistakes and best practices
• Best practice in writing procedures
• Capsule Procedure vs DB Procedure
• Clear Cube Insight
• Initialization process, Versioning and Simulation
• Data Export functionalities
• Moving data
• Rule Consolidation
• Selection option in procedure
• Allocation with Board
• Period-by-period recursion - Tips and use cases

Modeling

• Offset rules
• Naming convention
• Use of Nexel
• Normalize in High Concurrency
• Dynamically manage calendar settings
• Dummy entity elements for budgeting purposes

Screen and Reporting

• On-the-fly calculation Pros and Cons
• Navigation - Tips & Common Mistakes
• Application Navigation Design
• Reporting Layer: Optimize a report
• Use of Number Scaling
• Drill Actions
• Data Entry Saving Methods
• Comparison between different versions/scenarios in the same report
• Drill Anywhere Options: "Drill To" vs "Go To"
• Data entry input validation rules

System Admin

• Synchronize multiple data models
• Broadcasting & Notification Tool
• Data Access Control
• The backup mentality

Integration

• Triggering procedures with REST API Calls from within Board

Solution

• Migrate from BFC to GCR
• Period Types in GCR
• Equity Method Accounting BFC/GCR
• iXBRL with Seahorse