Procedures

Add Filter to a screen
Hi all, I have Screen1 and Screen2, in which i want to apply the same filter for Entity. Through a procedure I managed to apply the same filter (that we can call "Deal") to both Screen1 and Screen2, by selecting it from the Screen1. Keeping in mind that Screen2 is already filtered for "month", when i apply the filter…
dataflow problem
Hi All, i have a problem with a calculation between 2 cubes First of all, i want update the cube B (5 dimension) using the value of Cube A (2 dimension \the other 3 dimension i used the filter in the procedure) without delete the other part of the cube B. the Algorithm use the cube A and B explained before. The reason of…
Unbalanced Hierarchies - Allowing "selection mode" configuration in dataflow and export
Hello everyone, Yes, this is my first post on the community. Following internal advices and multiple external feedbacks I'm sharing this Idea that seems to never been raised. My idea is to allow a developer to configure the default behavior expected on an unbalanced entity selection, only by configurating option mode to…
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…
Possibility of not executing the open screen procedure trigger
Hello everyone, I'd like to propose an idea, which is to add to the ‘Go to screen’ action the option of executing the screen trigger procedure or not. Like the ‘Apply data selection’ option. So we'll have the option grayed out (if no trigger procedure is activated on the screen), or the option of checking/unchecking. This…
Optimal Management of Temporary Cubes to improve RAM Efficiency in Procedures
In my current Board implementations, I rely on temporary cubes extensively due to their impact on readability and performance management. However, I've noticed they can consume considerable RAM, especially during data-intensive procedures. Given this, I’m wondering: does it make sense to clear the content of temporary…
Speed up procedure development with virtual cubes “on the fly”
Hi @Product Management Team , at the moment, every time you realise that you need an additional virtual cube, you have to exit edit mode, switch to options, create a new virtual cube, save it, save the procedure, switch back to edit steps mode. And only then you can define the new data flow. It would be much better if a…
Add "Data Entry Dialog" as procedure action
1. What is your idea? I propose adding a "Data Entry Dialog" procedure action to enable the opening of a "Data Entry Dialog" during procedure execution. This would allow users to input values directly within a procedure logic/workflow. 2. What specific problem are you trying to find a solution to, or what new scenario…
Enhance interactive capabilities with modal screens
Dear @Product Management Team ! The idea is that the user's interactivity with the application could be significantly improved if developers had the option of defining modal screens. This refers to sub-screens that are displayed ‘above’ the current screen, can be resized and offer the same interaction options and…
Option to save and create next step in procedure
Hi Team, Hope you're doing good. This idea is just to make the developer's procedure-building task/habit more convenient. Whenever we create a step in a procedure, we are supposed to save it and then again click on the plus '+' icon below that step to add another step. If we have an option of clicking a button as 'Next…
Homepage Trigger
Hello! I think it would be very useful to have triggers also on the homepage of the capsules. The client would like to modify the capsule navigation and the information available on the home screen depending on the type of user that enters the screen (relationship that we have stored in a cube). As we do not have the…
Allow the use of Temporary Cubes on Smart Import objects
The idea is simple: Allow the use of Temporary Cubes on Smart Import objects as we do for Data Readers. It should be possible to type the Temporary Cube name and load data into it. The Temporary Cube should be configured in the Trigger Procedure launched after a Data entry action. Today, for the Smart Import object, we…
Display value in procedure step "show message"
Hello, it would be helpful if we could display a value in the “show message”-procedure step as part of the message and ideally also change it. Example: Planned values from the previous year are to be transferred to the current year, taking into account an increase factor. As part of the procedure, the user would be…
Use Procedure to dynamic select value for LAYOUT
Hi BOARD Team, I understand we can use procedure to achieve dynamic selection for Data Block reference. Can I do the same to make a selection to LAYOUT? Thanks
Smart Import trigger procedure - how to select based on the items present in the import ?
Hi all, I'm faced with an interesting issue when using Smart Import. We have setup an object so that users can import values from an Excel file. This is in addition to a screen where they can enter manually the values. In the basic data entry screen (based on layout then), there is a trigger which executes a currency…
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.…
B14: Enhance Debugger options
Hi Team, I was used to work with layouts in the debugger the same way as in a DataView Layout on the screen - adjusting column widths, exporting to XLS, searching for cubes to add as block into the layout… This is the behaviour in B12 whereas B14 behaves pretty differently in those cases: You can't export, you can't edit…
Support x-www-form-urlencoded body type for POST API Calls
At the moment, in REST API Calls if I have to set up a POST request with a body, the body type can only be in json format, which means that the only value supported for header Content-Type is "application/json". In some cases, especially API endpoints that return tokens but they are not standard OAuth2 flows (like in some…
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…
B14: Make better use of whitespace in procedure editor--adjust column width
Hi Team, whenever you're editing a procedure in B14—there's so much whitespace in between the columns "Action", "Detail" and "Note" which could be used better. One option would be to make the column widths adjustable (actions usually don't need that much space, but notes do for documentation reasons). Have a look at this…
ASCII Flat File DataReader - Move data file after reading
Dear all, I really appreciated the new "Delete file after reading" checkbox in procedures. I guess that, like most of you, our customer(s) require to move the flat file from its folder to another folder after its data was integrated into Board. However, most of the time, keeping the file in order to control the data loaded…
Multiple entity selection on step: Remove selection on entity and/or Remove selection on tree
Hi all, it would be great to have a multiple selection possibility on step "Remove selection on entity" and/or "Remove selection on tree". This would allow us e.g., to cluster five remove selection on entity steps into one step. Feel free to reach out if there are any questions. Kind regards, Atilla
B14: Add the possibility to comment on procedure groups
Hi Team, since it is now possible in B14 to collapse/expand groups of procedure steps (which is much appreciated), it would be really helpful if those groups could be commented on as well. This would help in understanding what a specific group is supposed to do even when the group itself is collapsed. Thus, it wouldn't be…
B14: Display correct information in If-Then-Else step
Hi Team, whenever an If-Then-Else step is created in a B14 procedure the system doesn't display the information correctly: The display in the list of actions will look like this Please display the information correctly and add the "Else"-information (whenever there is an else-step). Currently, the information is updated…
Setting time range and time entity relationships
Once a year, I plan a task to extend the time range by one year. I tried extending it by a year, which resulted in unexpected changes to the time entity relationships. In the example below, the number of child entities Month for FY=2023 should remain 12, but has become 3. Before the time change After the time change I have…
Temporary Cube in use y/n
Hi team, It would be a great advantage if the information as to whether a temporary cube is used in a procedure or not were directly available in the definition window. During the development phase, a number of temporary cubes are created and only some of these are still needed at the time of deployment. If the above…
Add Bookmark on Interactive Selection
Hello, We think it can be helpful to add a "+ Bookmark" button on Interactive Selection from a procedure as it already exists on the Selector object. Selector object : Interactive Selection :
On-the-fly Calculations: Pros and Cons
1. Abstract The term “on-the-fly calculation” refers to all the calculations executed directly at the layout level, meaning that the result is not physically stored in a Cube. This directly affects drill-down functionality and has advantages in terms of reducing the overall size. 2. Context During the development phase the…
Analytical Functions
Hi Board Team, I found the following calculation in one of the procedure. I understand From and To is used define the time range. But I cannot understand what Yearly Rolling Periods and Last Selected Period pointing to. If we use today 9th July 2024 as an example, which month range will the following pointing to? Thanks
Allow setting "Non-Exit" of procedure when cancelling interactive selection
Hi team! The idea is very simple and practicable for control flow in Board procedures: When using "interactive selections" in procedures, it would be highly beneficial to developers to have the option to intercept a user cancelling on "interactive selections" - in addition to the current default and only option of exiting…

Procedures

Discussion List