-
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…
-
Select Entity Based on Cube Option
Hi, I would like to suggest a new feature on select based on cube on procedures. Quite often I need to select tuples based on cube even if the sum of the tuples over a period = 0. In order to do so we have to create a Temporary cube. Could we imagine an option just like keep mode to set select tuples even if the sum of…
-
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…
-
Procedure Concurrency Management: Lock Edit Mode When in Use and Enable Read-Only Access
Hello Community, Currently, multiple developers can open the same procedure in Edit mode at the same time, which increases the risk of overwritten changes, loss of work, and version conflicts. I suggest implementing a concurrency control mechanism where: A procedure is locked as soon as it's opened in Edit mode. Other…
-
Linear Programming Problems in Board
How can we solve Linear Programming Problems in Board - Nexel or Procedures or any other tool ? Example contribution maximisation with limited machine hours, what should be the product mix. In Excel we can solve this using solver addin.
-
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…
-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
-
Selecting Months for Single Month & Multiple Month graphics
I am trying to set up a screen that uses a single month selection for a waterfall chart and multiple months for a graph of monthly figures. I have managed to get a procedure that selects the last twelve months, however I could not use this selection alongside the waterfall chart. I have tried using a custom time entity but…
-
204 - Procedure - Selection Step bug
Hello, I'm following the B14 204 course and I have an issue where when I want to select "Timestamp: ACTS - Actual Sales Upload" in my procedure, nothing is available. As you can see here, I cannot select anything. I've been told that it is a UI problem, but is there a way to circumvent it? I have reloaded the VM but…
-
Improve Procedure Sorting - Add Last Modified / Creation Date Columns
To improve the tracking and maintenance of procedures in Board, I suggest adding the following columns to the procedure list view: Creation Date Last Modified Date These columns would allow developers to: Easily sort and filter procedures based on recent changes Track the history and relevance of procedures Simplify code…
-
Include Temporary Cubes in Entity Analysis / Impact Analysis
Hello Community In the current Entity Analysis / Impact Analysis view, temporary cubes are not included — which limits our ability to fully understand how an entity is used across the application. ⚠️ If an entity is used in a temporary cube, and that temporary cube is used inside a procedure, the link between the entity…
-
Add Subtotals Support in Export Data Set feature for Unbalanced Entities
Currently, when exporting a Data Set from a cube that includes an unbalanced entity, the subtotals of that entity’s members are not included in the export. I suggest enhancing the Export Data Set feature to properly support subtotals for unbalanced hierarchies thanks
-
Entity - Code & Desc Width
Hello community, I’d like to clarify the following scenario: If we create an entity with a code and description length of 20 each, and use a data reader to load data, what happens if some rows have values exceeding 20 characters in either the code or description? Rows with a code longer than 20 characters will be rejected…
-
trigger an ADF pipeline via rest call API in Board
We want to set up a procedure to trigger a pipeline in Azure Data Factory trough Board to refresh our sql tables in the datawarehouse However when checking the log we get the following error: {"ControlFlow":false, "StackTrace":"System.Threading.Tasks.TaskCanceledException: A task was canceled.\r\n at…
-
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…
-
Dynamically manage calendar settings
1. Abstract In many cases, we will need certain mappings in our Calendar to define specific time frames for reporting and planning purposes. Some of those may be custom time dimensions and others might be created by mapping the standard calendar to specific periods. All those mappings have to be kept up-to-date. That can…
-
B14 - Less clicks, less blocking popups
Board 14 requires in some parts too many clicks which slows down the process working with e.g. the data model. An example - Adding an entity: B12: +Entity (1st click), Save Changes (2nd click), Next Entity … B14: + (1st click), Entity (2nd click), Create (3rd click), Wait approx. 3,5s for Popup to disappear, Close (4th…
-
How to flag periods between two dates
1. Abstract In some cases, calculations are only valid within a defined time period with a specific start and end date. Therefore, it’s crucial to first identify this period to ensure the calculation is applied accurately. 2. Context Many business processes rely on calculations between two dates. For example, calculating…
-
Procedure Dataflow
I have a cube at los level and I want to take that cube's values to the planning level of different LOSs. Considering los, sbu, sub sbu and competency are in relation and competency being the smallest and los being the largest. How could i do that
-
Multiple data model option for selectors
Hi Everyone, It would be incredibly useful to have a multidata model selection option within the selector object (similar to the option currently available for screens), allowing us to filter and select elements or members across multiple data models. This feature would enhance flexibility and efficiency by enabling more…
-
Data model panels - multidb view
For some of data model panels (entities, cubes, data read, securities) it would be useful to view items of all data models in a unique page. Through an added column "data model" I can filter of sort rows. Could be very useful for customers with several databases
-
When procedures triggered from screens fail you 😯
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…