Procedures

Is there any way to do a REPLACE instead of an INSERT in the BULK INSERT feature?
I'm trying to get a hierarchy directly upload from BOARD to a SQL Server, so this way we have the hierarchy on SQL and we can use it in our Views and Querys. The way that the BULK INSERT works let's me upload it, but every time I try to upload it again I will get a duplicate. I only want to have one register for every key…
Broadcasting & Notification Tool
1. Abstract Board offers the possibility to have a notification system to inform people about different events that are happening in the application, it also offers the possibility to share information with a larger population outside the application. 2. Context Three different features allow us to spread and share…
Procedure "Background execution" doesn't let me navigate the application while Wait is running
Hi, I am confused about the "Notify execution" feature when creating a new procedure. My goal is to make sure that a cube is cleared after 10 minutes of a client entering a screen. I was hoping to achieve this by creating the following procedure: All the messages are set up the same, only the time and the icon is different…
QUICK PROCEDURES LOG
Hi It would be nice have a the possibility, directly from procedure panel, to open a window with a quick log for the current selected procedure. Not so detailed (we have the log files for this), just with the information of - running time (start-end datehour) - if completed with some errors or not - the user that have run…
B11: Rename procedure's groups
Hi, it would be nice to have the chance to rename a procedure's group without the need of creating a new group with the right name and then moving all the actions to the new group and then to delete the former group! procedure modelling procedure
Temporary Cube vs Staging Cubes
1. Abstract When developers create a simple or complex procedure, they need to know that they have an advanced feature to ease their job by keeping the database simple and lean. This feature is the temporary Cubes. 2. Context Since B11’s introduction, developers can leverage the temporary Cube to store data temporarily and…
Breakpoint & Procedure Debugger
Hi everybody, I'd like to share an idea for an improvement which will be helpful for Board consultants and developers. When we try to debug a procedure, looking for issues or investigating unexpected behaviour, we usually place breakpoint in critical steps in order to evaluate the results of dataflows, active selections,…
Rule Consolidation
1. Abstract The rule is a key functionality that allows on-the-fly calculations between members of the same entity. The consolidation is a further step to physically store the result in the data model. This step is needed only in specific cases, usually when the calculated rows need to be reused as a source for following…
Extract cube/file to local path
The question below relate to a cloud installation of Board (v 12.4) Is it possible with a procedure (Extract cube) to write the file to a path locally on the user's computer. Shouldn't write the file to Azure Storage.
Data Entry Saving Methods
1. Abstract When saving data entry on a Screen, either the data entry Tick can be used or a separate save button. We’ll discuss which should be used, depending on several different variables. 2. Context Use of ‘on data entry’ triggers and save procedures are valid and applicable in different cases. To determine which…
Server Command - Batchfile not visible
Hello Togehter, i try to execute a batchfile with server command step. I placed a batchfile in folder /Board/Job, but it is not visible. Is there more configuration needed? Thanks for your Help!
Extract all Cubes – Filter Cubes by Entity
Description In Board it is possible to extract all cubes with procedure step “Extract all cubes”. It would be great to have an option to filter the cubes by entity or list of entities. For example I have a database with 1500 cubes. 600 cubes use the entity Planversion. I like to extract only all cubes with this entity. Use…
Screen Navigation with Procedure breaks Pager
Applying data selection to screen via procedure breaks default pager functionality. Example; I have a pager which defaults to the current period/month. I have a button which activates a procedure which does the following: - Remove Tree (Month) - Selection (some P&L item filtering) - Go to Screen - Apply data selection to…
Procedure to execute .bat and other actions
How can I make a process that runs a .bat (at the Operating System level) recognize that it is over and continue with another action.Thanks
pager procedure
Hello, I'm new in the forum, so please forgive me if the question is old and debated already. Is it possible that if I launch a procedure on a screen with a pager selecting a month there is no way to remove this selection from the proceure? I added a whole year in the selection to test, I made "Remove selection on entity"…
Impossible to reset selections after apply dynamic selection using a procedure
Hi to all, I have a problem regarding a procedure. In a screen I have created a label linked to a procedure that apply a dynamic selection on an entity. The selection run perfectly (to check this I have a label that shown the current selections). Unfortunately when I run the procedure clicking on the label, I cannot reset…
How to automate unloading a database from memory
Is it possible to automate unloading a single database from memory? I already start and stop the services overnight but I have some databases that are loaded into memory when data readers run just before the working day begins. They are taking up memory even though they are used occasionally. I'm happy for these DBs to…
flowing data from one particular year to another particular year ?
Scenario : i have a database . its time range is 2016-2024. have a history data for 2016,2017,2018 in source cube. i want to flow 2016 year data to 2023 in target cube how to achieve this ? Björn Reuber Pietro Ferrari Alexander Kappes please give me your inputs. Thanks & Regards, Ravi
how can I optimize my procedure?
hello, Well, I use 4 cubes in my procedure : Cube A (type: Single,structured on 6 entities + Year) : Yearly Budget Cube B (type:Date,structured on same 6 entities + Month) : Due Month Cube C (type:Single,structured on same 6 entities + Month) : Month flag Cube D (type:Single,structured on same 6 entities + Month) : Monthly…
How can i write my results back to cube using Procedures or nexel ?!
Hello All, I am trying to find out how can i write my resulted Columns (blocks made using Column Algorithm) and use it as a cube... For example : i have Dataview Layout of two blocks A and B present in the data already, i have created one Block, lets say Block C using Column Algorithm (A+B), now i want save this block as a…
Select the entity on a line with a procedure
Hello, I know that we have a Master Layout option when we set a dataview. But is there a way to select the by row the entity of a dataview line with a procedure? Thank you and best regards Marcel
Extract Board Metadata using Procedures or command lines?
While waiting for this featuresA "used by" feature on cube - Impact analysis , based on the suggestion of Björn Reuber, I've done quick ETL project using Extract Metadata features to do it myself using Talend (for xml processing) and a Board dedicated database to view the result. + However, I want to streamline the process…
Refresh of multiple screen/tabs
In 2 projects that we have developed in Desigual, 2 different group of users have asked us the same wish: To be able to refresh all the open tabs (since they use Board Web) at the same time, either when you perform a Data Entry or when you click a "Refresh" button. They usually work with 2-3 tabs open, using 1 of them for…
Copy/Paste Multiple Procedure Actions/Groups
I have often found that I've needed to build procedures with multiple groups that each hold five or six actions each. These actions have the same logic aside for a few small changes, such as five dataflows that use the same calculation but the destination cube is different for each one. It would be great to have the…

Procedures

Discussion List