-
Select entities to clear in a cube
Today we have the possibility, in a Procedure, to clear the Cube with existing selection ("Use current selection") or clear the whole Cube (default). If you only want to clear on specific Entities you will need to setup a save & restore selection and/or de-select & re-select specific Entities. Suggestion: Give the…
-
Option for logical/automated selection of Procedure on a DataView/other button
Giving developers the option to set-up a selection criterium (Algorithm) which runs one of multiple saved Procedures in the background. (see screenshot) That is to be seen as an addition to the manual selection of the Procedure by the user currently available.
-
Standard "integrated" copy function for e.g., Versions, Scenarios etc.
Hi all, it would be great to have a integrated copy function. Use Case: During a planning cycle we want to copy a Version 1 into a Version 2 (Entity in a Cube). Therefore, we have to create a procedure, define temporary cubes without the entity Version, add for nearly each cube a step with temporary cube not dimensioned…
-
More options in the BULK INSERT function
I think that the BULK INSERT function, has a lot of potential, whatsoever, it is very limited right now, it would help a lot to add more functions other than INSERT INTO. For example right now I'm trying to upload the hierarchies of our database to a SQL Database, if instead of INSERT we could also have access to the…
-
Level 200: Module 206 Copy PY Actuals to CY Budget
Hi there, I am having issues with my procedures to load CY Budget from the PY Actuals. The capsule procedure begins successfully, and can see it actions the data model procedure as the timestamp updates. However, the data flow step in the Data Model procedure does not appear to run successfully, and I do not get the…
-
Extract/Import Trees Unsorted
Hello, I'm sure any admin of BOARD has faced the issue needing to refresh Development Cubes/Entities with new info from Production. I'm sad to say that this process is FAR less straightforward than it would seem. It is very frustrating to always have to follow the steps of : A) Remove all sorting of entities (Production)…
-
Predefined PDF-Export
My client has a requirement to export their P&L report, balance sheet report and other reports as a PDF. The structure of the report has 3 elements: Report information: Name of the report, name of the company, additional information such as "YTD view" and "Disclosure in TEUR" (position: top left). Logo: Logo of the…
-
'Exit Screen' Procedure step to close tabs in web client
I am proposing a web client behaviour for the existing 'Exit Screen' procedure step. Currently this procedure step has no action in the Web Client, however within the Windows Client, upon execution of this step, the current open screen is closed fully, rather than navigated away from. It would be ideal if this step had the…
-
How to merge actual in planning cubes
1. Abstract Forecasting is a prediction or projection about a future event, depending on the past and actual performance and trend. A forecasting process uses historical data to predict future numbers and allows organizations to project future results for budgets, expenses, and other financial and operational data based on…
-
Save data entry automatically runs procedure
1. What is your idea? When using the standard save dataentry function on a screen (F9, from sliding panel, from WIN Client, from procedure, in advanced data entry) BOARD should be able to run a predefined procedure 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond…
-
Culture-sensitivity with @datetime in Smart Import
Hi, I have a bit of trouble with culture and the formula @datetime. I have a cube that is populated 2 ways: either the user uses a smart import object to fill other cubes, and then the datetime information arrives into this timestamp cube using a formula. Or, if the users don't want to input anything, they can click a…
-
How to log procedures' execution with timestamps
1. Abstract Admin users often require checking the time execution of a procedure and even the user who launched it. Board provides a standard functionality to review the logs, but it is possible to put in place a customized solution. 2. Context In Board, there is a standard functionality to keep track of the execution of a…
-
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…
-
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
-
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,…
-
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.
-
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"…