-
Show Message - Yes/No Option
Hi there! I think it would be really useful to be able to change the text in the Yes/No option. It can be Yes/No by default, but maybe you can add a way to customise it. An example would be this: It would also be great to change the colour of the button (not always blue).
-
activate Layout for Panel Container
The Panel Container is great for grouping other Toolbox-items like Label, Button, Dataview and so on. The Expander Container is a good choice to store many items on limited space. Together they are very powerfull. Espacially on admin-screens and Dashboards. I miss the Option to hide a panel container inside a Expander…
-
New Datasource: SAP Data Lake
Customers in DACH-Region are mainly driven by SAP. SAP Cloud is increasingly being used by customers. SAP data and non-SAP data is stored there. It is necessary to read and write data from SAP Data Lake. Connect to Data Lake Relational Engine Using the .NET Driver
-
In capsule, how to restrict procedure launch for read only user ?
Hello, In BOARD we have a P&L capsule shared between 2 user groups Controlling user that are allowed to launch procedure that may change data like clear data / reload data from ERP / launch allocation Reporting user that should only have read only access. They should not be able to launch procedure. The issue is that "Read…
-
How we can current year 2024 sales values into Budget year 2025 using the procedure?
-
How use an algorithm picture on parents aggregation
Hello, I would like to use my algorithme picture on parents aggregation, When I use it it's working on children but not on parents. Have you a solution to display the picture on parents ? Best, Shanèse Rouabah
-
Level 200 Module 204 Data Reader
Hi, how do I get the source files that I have to load in Step 8 in the Data Reader ? Can I download it anywhere?
-
How to manage three different rules in the same layout
Hi, I'm in the situation described by the title. The rules are based on the same entity, but I want to use them in the same layout due to the type of calculation the user selects. Have you got any tips?
-
Quick preview of the data in a cube
To get a preview of the data in a cube we have to create a screen containing an appropriate dataview. In order to get a really quick preview of the data in a cube it would be helpful to have the option of saving one or more views of the cube data as part of the analysis of a cube (screenshot below). It should be possible…
-
New Exit Procedure Step for exiting/stopping the complete procedure process (for nested procedures)
1. What is your idea? Introduce a new procedure step which exits/stops the complete procedure execution even if the procedure which uses this new exit step is a nested procedure (was executed inside another procedure). 2. What specific problem are you trying to find a solution to, or what new scenario would this idea…
-
Celebrating 365 days of Community!
Congratulations to our Board Community members and friends! One year ago, we started out on a new journey together, bringing together more members, sharing knowledge in new ways, and growing the collective wisdom of a dedicated community of Board users and enthusiasts. I'm thrilled to say—it's working! Here are some 2023…
-
Display Year
Hello community, I looked in the substitutions formulas but couldn't find any one that can show just the year in a dynamic way, so that when I'll be in 2027 I'll have 2026 as N-1 and 2027 as N. I tried several ways in the procedure : @Year, YYYY, @année, a and then I did a period offset.. none worked. I did a cube with…
-
Easier management of RULES
Often we need to delegate the management of the RULES to some User. In order to make it easier, it could be helpful to have a way to access and edit the RULES w/o accessing to the related DB area. Just for example, this can be solved using a standard Board Report (see below) where the RULE can be visualized and/or defined,…
-
GCR 1.0.2 is Now Available!
A new GCR version (1.0.2) is here! We are happy to announce that a new GCR version (1.0.2) is now available for customers and partners! 1. New features included in this release 1.1 Automatic Adjustment Trough this new functionality, users can now create automatic adjustments and calculation rules directly from the GCR UI.…
-
Programming language
Hi, which programming language was used to program the Board 12 Engine? C#? And which web framework was used to implement the Board 12 clients for the browser?
-
Having the Ability to Drill Down When Using Vertical Block Alignment in the Data View
Hello Currently, the drill-down feature is unavailable when using vertical alignment in the Data View. I suggest adding this functionality in the upcoming updates to enhance efficiency and improve the overall user experience. Thanks, Akrem
-
Selection status of a step in a Procedure without running it
Dear Community, I think it could be very helpful to have something to track what is the selection status until a step of a procedure. It should act like the breack point while debugging but whitout running the procedure because it's not always possible to do that.
-
Level 200: Module 205 - incorrect totals
Hi, I cannot match back to the final result required in the Sales Actuals screen in the last stage of module 205. I have followed all the steps for correction and can not find anything that does not match the set up instructions. Please could you advise where I may be going wrong.
-
Debugging training
Hi all, In many occasions new BOARD developers/consultants don't start a project from scratch, they start from an already built solution and they need to solve issues or to evolve it. From my point of view, the "debugging" is as important as the construction, so I ask for an specific training in the academy with the…
-
Level 200, Module 204
When i run procedure "ACT - Sales Data Load" or directly data reader "ACT - Units and Sales data" second time it shows that one record is discarded and it does not load any data into cubes. When I restart platform it works one time and then error again.
-
SQL LOG 👀
Hello Dear community ! 👋 Where can i find the Log after running an SQL DataReader? (the log box is cheked) Thank you in advance 😉
-
Board Public API: Include "maxItemNumber" as well
Currently the API only returns the number of items when using "/public/{dbName}/schema/Entities". Can this please be extended to include the "maxItemNumber" as well? Then we can track when the entities are full. Unfortunately, it often happens with our customers that the entity fills up and we don't notice. The frontend…
-
How to set parametric WHERE clause for SAP
1. Abstract With the Theobald Board Connector, a SAP-certified middleware is available to load data from SAP systems (ERP/BW) to Board if the database of the system cannot or may not be addressed directly (e.g. HANA via ODBC). More information can be found here: In the simplest case, data is read from SAP tables, i.e. the…
-
How to trigger SQL server actions
1. Abstract This article discusses the possibilities of using ROLAP cubes to write flags into an SQL server, thus triggering actions on the database side, and how to process this flag. 2. Context Usually, data pre-calculations are loaded into Board from a SQL server, but there are times when we need to initiate actions on…
-
Rest API: Additional output/storage formats for REST API call (e.g. temporary cube)
The only output format (right now) for an REST API call is to save it to an CSV file. This CSV file can be used to load an temporary cube. A direct load (without saving the file to disk) into a cube / temporary cube would be a great enhancement.
-
Switching versions in a single screen
Let's suppose we are on same screen and I want 2 versions of the same screen. In first version "v1" user is entering the data and then user switched to second version "v2" where data entry is locked. I want that after entering the data, user can go to the "v2" version by just clicking on the label.
-
updated ETL Functions list 🫡
Hello dear community 👋, Can you please share with me the latest list of ETL function (other than Right/Left/Len/concatenate) By the way, we are using Board V 12.6 Thank you very much in advance👍️
-
Error during installation of OPC
Hi, during the OPC installation, this error appears in the step where the DATA PIPELINE credentials are entered, does anyone know why?
-
Probably The Best Alternative to CSV Storage: Parquet Data
1. What is your idea? Board support a lot of datasources. Probably the most used are csv files. However, with ever increasing amounts of data, working with csv files becomes a pain. Parquet files can be an alternative. Head-to-head comparison CSV Parquet Row-based storage format. A hybrid of Row-based and column-based…
-
Execution of single procedure steps for testing purposes
For testing purposes it would be helpful if a single procedure step could be executed by for example right-click on the step. As a consequence it would not be necessary to either deactivate all the other steps or to create another procedure containing only the step which is supposed to be tested.