-
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…
-
Validation of End Date Earlier Than Start Date
I have two data cubes with the month dimension, where a 1 is stored in the cell corresponding to the date selected by the user. Cube 1: Start Date Cube 2: End Date I need to implement a validation so that if the user selects an end date that is earlier than the start date, the system displays a warning message prompting…
-
Pass the Screen Name to Capsule Procedure
Hi all, Is it possible to pass the Screen name to capsule procedure? The screen name will dictate which Group of steps will be used in the processing. I wanted to combine the multiple procedures we created into one which will have an if clause that will check the screen name and go to an appropriate group for processing.…
-
End Date on a Day (as Start Date)
In the rows I have the day entity. In column 1 the possibility to enter a number of new hires and in column 2 the end date for the new hires. The date on which I enter the new hires should represent the start date. In a procedure, the number of new hires should now be written to the days from the start date to the end…
-
Level 200 : module 211 - SET - Flag Budget and Actual Years
Hi, I don't understand the procedure : SET - Flag Budget and Actual Years In particular, the calculation of the data flow when the time function is selected on "Last value" in the cube "SET - DE - Planning Year". What does that mean ? What is the result if for exemple the value in the cube is SET - DE - Planning Year is…
-
Procedure: Extend Calculation on new tuple for all members
We have a source cube (Input Cube) as shown below with dimensions highlighted: We have a target cube as shown below with its dimensions highlighted: How does "Extend calculation on new tuples for all members" affect when we are copying data from source to target cube? What happens if we select all/ any of the members and…
-
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…
-
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.
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
Level 300, Module 305 - Functional Q 1
Hi, I am currently getting an incorrect response for the CY Forecast amount for Grey Pearl Stud. I have checked the steps and instructions numerous times but just cannot seem to work out where the issue is. Having looked at what the correct answer/amount is, it seems for whatever reason my procedure is doubling this…
-
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…
-
Level 200, Module 205 - Impossible to create a 'Call procedure' step
Hello, I'm stuck in the Level 200, Module 205: ACT - Sales Data Load Capsule Procedure. I need to create a capsule procedure that contains a group 'Call DB Procedure' with the step 'Execution flow: Call procedure'. However when I try to do this I cannot select any procedure in the drop-down, it's simply greyed out. I've…
-
Addressing Timeout Issues in Azure ML with Batch Inference
Dear Team, During inference on high-volume datasets in Azure Machine Learning—particularly those spanning multiple countries, departments, and similar entities—we have encountered procedure failures caused by timeout errors. These occur because the inference process does not complete within Azure ML’s default maximum…
-
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
-
Groups on DB Procedures
This would be a simple change that would be hugely beneficial for implementation teams. Naming conventions are always abstract, this way, it could allow for a distinct way of grouping processes.
-
Saving @Selection_Ex() result
Hi all, We are working on new functionalities for cost allocations, where we will need to store the explicit selection made by the user. This selection can be done on 1, 2 or 3 different trees, containing up to 30 entities each. I don't want to store the resulting selection at the lowest level of the allocation driver…
-
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…
-
Pacer vs. Selector
Hi there, I have a screen in which I have a pacer which is filtering months. I created a procedure that should apply the filtered month to the next screen. However it doesn't do it. Therefore am I correct that you need to have a selector always when you want to screen selections in a procedure? Thanks, Maik
-
Possibility to apply selection in "Export screen data to xlsx" procedure step
When a procedure is triggered from Screen A to export layouts from Screen B, there is currently no way to apply a selection on Screen B to export a filtered dataset. It would be very helpful if the "Export screen data to XLSX" step could optionally inherit the selection that is active in the procedure. We are using this…
-
Can you Procedurally Export to Excel?
We have a budget cube that is loaded to via the smart import object. After a bit of transformation on our end, we want our users to have the ability to export this data in xlsx format (same format they initially loaded to in the smart import object) for their own purposes. We would like for there to be an interactive…
-
Admin / Task Scheduler - Allow scheduling of a task multiple times per day
Hi, This issue has been raised multiple times with Support & Customer Success teams for the past 6 years at least, but since it's not moving, I'm posting it here to collect additional feedback from the community. Issue : Currently there is no possibility in the admin portal task scheduler to define the execution with a…
-
Export Users Task in Procedure
Hi Team, We got a recent request from a customer to check if it is possible to have a report, of the current users in board with the information of the profiles/ license assigned. Currently we know that this can be viewed by an Admin user with a Developer license by going to the System Administrator (for On-Premise),…
-
How to use Nexel to select custom time periods
1. Abstract While conducting reporting, the essential requirement often arises to compare data across various time periods. This article introduces a method that enables users to choose a specific custom timeframe directly on the screen. Using a designated cube, users can dynamically select pre-defined custom periods. 2.…
-
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…