-
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.
-
How to color only the top of DataView
Please tell me how to color only the top 3 numerical values in the data view.
-
Label subtitution formulas to view a layout selection on a specific entity
Hello using substitution formulas I can highlight in a label the selection for a specific entity. e.g. @Year returns the selected year. But, as far as I understand, if I want to show a layout selection I can only use @Selection_Ex(Layout="Layout_Title") without the capability to choose one entity Is there any way to obtain…
-
EXPORT EXCEL ENTITIES, CUBES, PROCEDURES, DATAREADERS LISTS
Hello, It would be very nice, if, from a screen of cubes, entities, DR or procedures, we could have a button for exporting properly in excel (choosing columns to be exported if possible ( just name, or name + code + date + size ….) Thanks for your attention😊
-
Function similar to ABS of excel
Is there any function similar to ABS function of excel to set rules in board.
-
RENAME A PROCEDURE
When we change the name of a procedure, we need to find all the procedures that call the modified procedure in order to update the new name, If this is not done, the procedures will not execute correctly. Doing this work is very tedious We understand that this request has already been made, but that Board considers the…
-
SUBSCRIPTIONS
Hello, Would it be possible to access the menu "view all subsciption" before being in a menu, as it shows all subscriptions wherever they come from ? It would also be useful to have a link to open the source from this page. Thanks for your attention 😊
-
Save filter values in selection
We would like to have the ability to set a permanent filter value when a selection is made on a screen. This selection should remain even if the entity values are deleted. This is currently not the case. For example, if customer XYZ is currently filtered on the screen and the customer is deleted from the entity, the filter…
-
Administration: More management options for all users presentations
It would be good for us as administrators if we had more management options for all users' presentations. E.g. an overview page showing which presentations are available and with whom they were all shared, if necessary the possibility to change assignments here as well. As a current workaround, we register on behalf of the…
-
How to manage the currency conversion
1. Abstract Nowadays, most companies work on a global level and accordingly also have the need to be able to display and edit their KPIs in different currencies while keeping the ability of a consolidated view. In this article, we will first show how to implement a currency conversion where different local currencies and…
-
Delta Lake for read/write parquet files
What is Delta Lake? Delta Lake is an open-source storage layer that brings ACID (atomicity, consistency, isolation, and durability) transactions for big data workloads. Key features of Delta Lake Feature Description ACID Transactions Data lakes are typically populated through multiple processes and pipelines, some of which…
-
Level 200: Module 212 - Not seeing any data after running Procedure
I am not seeing data in after running the procedure in module 212. See my screenshot vs the training expected result. Any idea on how to troubleshoot this would be appreciated. Thanks Emmanuel
-
Disable the sort action on the DB Log
Hi Team, We faced this issue multiple times with many partners, where the database logs are being sorted (either by mistake or to check something). Group by logs could be useful, but the database logs sorting always adds to the confusion. thanks, Aniket
-
How to create a workflow process
1. Abstract Many organizations would like to automate approval processes and workflows through Board software in order to create a reliable and standardized series of steps which guide users to ensure work is completed and approved the same way. In Board, a workflow intended as an approval process can be designed through a…