-
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…
-
Level 200, Module 207: After "Apply 5% Increase" the "CY Budget" Data disappears => no data
When I click on "Ally 5% Increase" the CY Budget data disappears and no data is left. Before: After: Label Config: capsule procedure: data model procedure: Do you need further information/screens? Many thanks in advance!
-
Level 200, Module 206: Label with timestamp shows "0" after click/trigger on "Initialize Budget"
When I click on "Initialize Budget" its loading the data, but the timestamp doesn't appear respective is "0". capsule procedure: data model procedure: Do you need further information/screens?
-
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.
-
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…