Procedures

Procedure - DataFlow - Algorithm of dataflow (c=a*b) should show the headings of source blocks
When editing the blocks of a DataFlow LayOut, it's possible to set headings to each blocks. When saving the DataFlow, the heading of the target is displayed in the algorithm / detail, but not the heading of the sources. It could be usefull to have the headings set in LayOut for sources as well.
UBH - Using dependancies in Procedures
Dear all, Since the integration of UnBalanced Hierarchies, a world opened to us! Including the dependancies selections (Leaf, Descendants, children, etc…) of the UBH in a DataView. However, these dependancies can NOT be used in Procedures. It could be usefull to easily calculate the weight of a member Vs its direct parent.…
REST API - Execute Procedure with Selection
Selections are an elementary concept for controlling procedures in Board. When starting a procedure from a screen, a start selection is usually passed with it. We need this possibility also, if we start a procedure over the rest Api. The selection could be passed in the body as JSON. Currently only the database name and…
Adding search engines in all process options
It would be very helpful to have a search engine like "Select Entity Based on Cube" or "Clear Cube" (Picture) in all options where a selection has to be made. There are many options, such as "Remove Selection on Entity" or "Cube Align" (picture), where you have to search for entities or cubes by scanning a list.
Audit/Record changes to procedures / lines
As an on-going maintenance task, we frequently have to modify procedures (add more lines, modify existing, disable lines, etc.) It would be nice if (upon saving) the username/timestamp and action is recorded against each line (e.g. added, disabled, modified, etc). This can be used, in part as a version control mechanism.…
Step call procedure: deactivate checkboxes to copy current selections (back) by default
Minor idea: when creating a new procedure step "call procedure" the two checkboxes to copy current select / copy back current select are active by default. I have often seen both checkboxes activated in applications and quite often it turned out they have no purpose - the developer simply did not think whether it´s…
Data Model object comments
For Data Model objects it would be informative to have to possibility to add comments and notes. For example a Procedure, under “Options” or a new tab, give the developer the possibility to write comments i.e. the purpose of the procedure, when it was last updated, who created/updated it. It could either be one big…
How to flow data among blob cubes using dataflow procedures ?
.
Dynamic Selection
Cloud Version: 12.6 0288217 In a Procedure, I use a Dynamic Selection within a Selection (see screenshot 1). The cube, the selection is referring to has one entity (DustinUser). But no DustinUser is ticked in the cube. The cube is totally empty. When running the Procedure (Step 12), all members get selected (see screenshot…
Renaming database procedures
I would like to be able to simply rename database procedures.
Clicking outside of a Show Message box should not register the click as Yes
If you (accidentally) click outside the Show Message box, Board will register it as a Yes/OK and continue the Procedure. Suggestion: If clicking outside the box, nothing should happen.
copy procedure from one capsule to another
would be great if one could copy or save a procedure from one capsule to another where also temporary cubes are copied. That would massively simplify the copying or even moving of a procedure instead of recreating the procedure by copying the steps and re-creating the temporary cubes.
Clear Cube Insight
1. Abstract Clearing data in a Board application that has a large dataset, and high concurrency, needs to be done with care to avoid an unintended consequence. The approach you use to clear data has an impact on data retention and can impact performance. The purpose of this article is to review the options available for…
"Run as administrator" option for "Advanced broadcast rule"
From my point of you it would make sense if there would also be a "Run as administrator" option for the broadcast function "Advanced broadcast rule" so that the developer can explicitly run the broadcast function without (previously removed) security selections. Right now there is no such option so the broadcast function/…
Nexel configuration storage - Procedures
Where Nexel is used in a procedure it would be helpful if Board made it mandatory to store the Nexel configuration - or enabled developers to see the Nexel configuration. Board's 'Best Practices' document goes through the need to store it clearly (link below) - but it would I feel be justified to make this embedded in the…
Breakpoints for a regular User
Hello, Are breakpoints supposed to be ignored for a user with a regular User license? I'm trying to investigate a Procedure that fails when running as a User, but not as an Admin. Can't find any documentation regarding this. Thank you
Split a Yearly amount in Months according to Start Date and End Date
Dear All, 'Hope you're fine! I'm looking for splitting a full year amount between months according to a Start Date and End Date. For now, I identified 4 cubes: see below. All cubes have the 3 dimensions: Scenario / Company / Product Full Year amount (single: at Year level) Start Date (Date: at Year level) End Date (Date:…
Flexibility with procedure step "Show message"
Hi all, it would be great if we could have more flexibility with messages e.g., Custom buttons (additional button - or rename of existing ones) Custom icon / header Custom color Kind regards, Atilla
Align Save button in Procedure
This is a minor thing, and could probably easily adjusted. When hitting the Save button on a Dataflow step in the Procedure, the left side of the Save button is on top of the right side of the Procedure Cancel button. In case a double click is registered when hitting the Save button, you could accidentally exit the…
📅 Add an culture insensitive variable : @datetimeISO
Currently @datetime is culture sensitive which make it very inconvenient to use in most case like with APIs. I know the following idea has been accepted but still, it would be a great addition to have @datetimeISO with ISO formats. Source :
Triggering procedures with REST API Calls from within Board
1. Abstract This article discusses the possibilities of triggering Board procedures via Rest API Calls from within Board itself and the how’s and why’s of this approach. 2. Context The Board Public APIs empower external systems to seamlessly interact with a Board application. By utilizing REST API calls, you can, for…
Procedure Visibility in Security
Just like Cube Visibility in Database Security, it would be meaningful to have the same security functionality for Procedures, where you can have Cubes that control Procedures that are possible to run. It could also be applied to Data Reader (Visibility).
Logging Improvement - diagnosticYYYYMM.log
Hello all, Within the file "diagnostic«YYYYMM».log", there are various actions that are called out as part of the log. Specifically, if a process clears a cube without selections. [2023-11-01 08:48:10.648 -04:00] WARN { "Username": "x", "CorrelationId": "x", "Procedure": "cap - Update - Volume MS", "TaskId": "x", "Action":…
Unexpected behavior with empty Procedure Groups
Cloud Version 12.6. This might be considered a bug, but I will report this as an Idea of changing Procedure behavior. When a Procedure contains an empty Group, Board will immediately jump to the group below and consider the steps from the group bellow to belong to the empty group. However, if the empty group instead has a…

Procedures

Discussion List