-
Capsule Procedure vs Datamodel Procedure
1. Abstract While developers are facing procedure creation, they need to understand when it is appropriate to use data model procedures vs Capsule procedures. 2. Context As developers, it is our responsibility to always keep the long-term maintainability of our solutions in mind. Procedures must be developed in a…
-
Flexgrid: Aggregation Rules definition per Entity members/KPIs
We lack the possibility to define different aggregation rules and levels for different items of the same entity. For example: We have an entity "KPI" We have some Ratios in our KPIs Ratios need to be calculated at the granularity level that is currently displayed on the Flexgrid In Flexgrid, calculations are being…
-
Clear Cubes / relaod cubes linked to an entitie by procedure
Hello, As a developer, it really time consuming to extract all the database and to reload it, all of that just for improving a max item number (for example) There is workarround of course, clear specifically cubes concern and reload them through datareader but the work is really time consumming when the entity is used many…
-
Article How to loop procedures
Hi, Just reading through the article : How to loop procedures One part says Loading the extracted sequence into the Enumerator Cube so it looks something like this: How do I load data into a Temporary cube? Via the Data Reader I cannot see them. Thank you Maik
-
About Sparsity
Hi Team, I am reading the Best Practice Screen, which suggests that version / scenario can be set as Dense to improve speed. https://community.board.com/discussion/16440/sparsity Just for the learning purpose (not means I will change it), we should review the folloing Sparsity? Thanks
-
Allow drag & drop reordering of cube versions
Hi there! It would be really useful to be able to reorder cube versions by dragging and dropping them. Right now, if you create a new version that, for performance or logical reasons, should be placed in position 2, but you already have 6 versions, you must delete all of them and rebuild them in the right order. It would…
-
Enable Draggable Field Mappings in Data Reader
Use case: When configuring fields in a data reader, it's not uncommon to forget a field (e.g., Customer Description in Screenshot 1 below), or the data structure may evolve, introducing new fields or changes in hierarchy over time. Currently, if a field needs to be added or repositioned, users must clear all existing…
-
Ability to change Entity Codes en masse
This has now occurred for two clients in the past few months, so I thought of posting this idea for consideration. In both cases, the clients moved from one ERP system to another; and updated the GL Codes or Item Master codes - and the expectation is that Board will use the new codes and historical data in Board is not…
-
Clarification on “Max Item Number” when creating an Entity
Hello, I would like to ask for clarification regarding the Max Item Number option when creating a new entity. When the Max Item Number is set to Auto, what exactly does it mean? Does the entity accept an unlimited number of members? Or is there still a hidden system limit that we need to be aware of? I want to better…
-
upload for all file types in Blob cube & download file using button
There should be option to upload multiple types of files in a blob cube
-
Possible to load unbalanced hierarchy throught smart import ?
is it possible to load an unbalanced entity throught smart import ? Because i can't find de parent code in the mapping part
-
Charge unbalanced entity with datareader
Hi community When i want to charge an unbanlanced entity with my datareader , i always have one rejet for the parent code not found and in the relationship part i find that the parent code is missing , do you know where comes from the problem?
-
Trigger a Board Data Model Procedure from Excel Add-in
Hi All, Has anyone tried to trigger a Data Model procedure from Board Excel add-in using an API or any other approach? Regards, Vikash
-
Google Doc Connection
Hello everyone! I have a question: does anyone know if it's possible to establish a connection between Board and Google Docs? I have a questionnaire that nearly 200 people will need to complete, and the different scores they enter should be aggregated to calculate averages. Ideally, they could fill it out in Google Docs,…
-
What is the purpose of "Position Changes" in the Data Model Transporter?
We recently executed a backup and restore of our core data model from production to non-production. Everything was aligned momentarily; However, as soon as we developed a couple new objects (cubes, rules, entity formats), the data model comparison tool exploded to show several hundred changes between environments. Of the…
-
Introduce a "Mini Map" View in Procedures
Problem : When working on long and complex procedures in Board, it's easy to get lost navigating between multiple steps, loops, and conditional blocks. The current linear view makes it hard to maintain an overall understanding of the structure, especially for debugging or reviewing purposes. Suggested Feature: Add a Mini…
-
"Preview Mode" in Dataflows
Hello Community Problem: Currently, there is no way to preview the output of a Dataflow without executing it entirely. This leads to several issues: Risk of overwriting existing data if the logic is incorrect Long execution times, especially without perimeter filters Difficulty testing or validating transformations safely…
-
Limitations when pushing data from MDB to RDB via Dataflow
All, Are we aware of any limitations when pushing data from an MDB cube to an RDBMS using a dataflow? Scenario Overview: We have an MDB cube composed of four entities - 3 General Entities + 1 Time Entity Entities Max Item Item Count Entity 1 100000 30141 Entity 2 1000 41 Entity 3 100 8 Month Infinity 204 The goal is to…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
level 200 - module 203 - Build a Screen to visualize the loaded actuals data
Hello, I am having a challenge with previewing data after completing the steps below My preview returns empty. with just product in the first row and total in the second. No other data is present. I suspect that I may have missed a step in the set up of the temp cube, but I struggling to find what it is based on the…
-
Unsynchronized Procedure names
Hi, I needed to adjust a procedure that is assigned to a field in a Dataview. However I could find it in the data model. Because it has been renamed at some point How can I synchronize the names to ensure someone can find it? Thanks, Maik
-
Why does the "Previous Year" time function still return current year data?
I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or…
-
Normalizing time hierarchy
I have enabled the week dimension in time range settings. This is the setting windows. The hierarchy looks something like this - I have updated the hierarchy and normalized but the aggregation function is not working as expected. When we are trying to roll up from week to fiscal year the total is coming wrong.(I have…
-
Account Set up
Hello Community! My boss/Board expert just left, and I have a simple question for your experts out there! Where can I go to see how an account is calculated in the P&L? Thank you for your help!
-
Data Reader Configuration From Local System
Hi Team, I attempted to configure the data reader to load a CSV file from my local system. However when i specify the file path, no files appear to be available or recognized by the system. Please advise if there are any prerequisite configuration or settings that needs to completed before this step? Thanks for your…
-
Question about dynamic selection with two parents of the same entity
Hi Community, I’d like to share a slightly complex use case that might open a discussion on potential improvements or clarifications around how dynamic selections work in Board. 🎯 Context: I have an entity called Month, which has two parents: Month of the Year → contains values like January, February, etc. Year Period →…
-
Procedure Select step critical bug
Hello, I am following the 212 module and I am working on the BUD - Consolidate Budget into P&L procedure. after following every step, I am stuck at the Select Account step in the sales group. The UI element that is supposed to allow me to select an Entity isn't working. No bypass that I know of is currently working (not…
-
expiration of the training environment for the 200
Hello, I have a question, after the expiration of the training environment for the 200, is there a way to recover what I did before (like the screens I created, procedures ... ) or not?
-
Extract / Reload / Clear Cubes by Group and Support for Sub-groups
Hi Community Currently, procedure steps like Extract Cubes, Reload Cubes, and Clear Cube apply to all cubes or to manually selected ones. I suggest two improvements: Add the ability to perform these operations by cube group(or subgroups - improvement 2) (via dropdown selection) Introduce the concept of subgroups within…