Procedures

Multiple entity selection on step: Remove selection on entity / Remove selection on tree/ Clear Cube
Hi all, it would be great to have a multiple selection possibility on the above steps mentioned in the title. 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
Add a few Substitution formulas
Add a few Substitution formulas: Substitution formulas @computername equivalent to %computername% Substitution formulas @userrole matching the user role Substitution formulas @userdisplayname matching the user display name Substitution formulas @timestamp matching %timestamp% that is culture insensitive (unlike @datetime)…
How to use period by period recursion
1. Abstract This article will highlight the advantages of seamlessly incorporating a native functionality, like the “Period by Period recursion” function, within a business context. It illustrates how this integration simplifies tasks, boosts scalability, and optimizes maintenance, providing practical insights for its…
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
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…
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…
Line by Line comparison of Procedures (Capsule and Data Model) across servers
Currently there is no way to compare if the procedures line by line in our development system and production system are the same or what has changed. The only thing that capsule snapshot or data model snapshot comparison does is it tells us there is a difference but does not tell what specifically is different. This is…
Enhancing the Running Tasks Page
To improve the Running Tasks page, we propose adding features that provide developers with more detailed insights into running processes. Suggested Features: Current Step Progress: For tasks triggered by procedures, display the current step being executed alongside the total number of steps. This would give developers a…
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…
Enable "Cut" for Procedure Steps
Hi, when you create a procedure with a lot of steps and you want to move a larger amount of steps within the procedure (for example into different groups), you currently have to copy&paste and then manually delete the old steps at the initial position. It would be very helpful if you simply have to option to cut&paste.
Temporary Entity
Just like we have temporary cubes in procedures sometime we need dummy entites of one or two members may be more depending upon calculations, so like temporary cubes how about having temporary entites??
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…
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…
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…

Procedures

Discussion List