-
Level 300, Module 302: New Sales Person Master Data File Required.
Hi Support, I'm using the Board Academy Cloud to complete the course Level 300, In the data Reader ONE TIME - ACT - Units and Sales, there are many records rejected because of new sales person in the file. Could you please help to provide the file for new sales person? Moreover, since Board training environment is quite…
-
Move specific screens from one datamodel to other
Hi Is there a way to moye specific screens from one data model to another data model? The data models are on the same server. We have build some screens in a Capsule for data model A and want to move some to capsule for data model B. The capsule snapshot does really do it since in this gave in whats to level B with…
-
[Board V12] - Admin console port 8443
Hi, Where can i change the 8443 defaut port for admin portal url? 😶
-
How to do top-down allocation of an integer value
1. Abstract The article explains a possible method to ensure that top-down allocation of an integer value generates integer details through the redistribution of decimals. 2. Content In this example, we have a cube QTY [Year, Customer, Product] which is planned at a high level [Year, Product, Country] where Country is the…
-
Level 300, Module 302: Create a temporary validation test Screen to confirm all data has been loaded
Hi I'm using the Board Academy Cloud to complete the course. In step 15, we create a temp validation screen to check that the MANUAL - ONE TIME - Load Sales and Expenses procedure ran successfully. My ACT - DF - Sales GBP column is empty. I eventually tracked the error down to an [Rec.0] Error : RBT0071 Out of Memory,…
-
Data Reader Upload files
Hello I would like create a Data Reader and use my own files to try some use cases. Would you mind tell me how to upload my files in the Board local storage so I can use them in the data reader Best regards, Anis
-
Level 300, Module 302: seems there is no data has been loaded
Hi I'm using the Board Academy Cloud to complete the course. In step 15, I created a temp validation screen to check that the MANUAL - ONE TIME - Load Sales and Expenses procedure ran successfully. Both columns - ACT - DF - Sales GBP and ACT-DF-Expenses GBP are empty. What could be the reason? Thanks
-
Numeric cubes only in double
Hi, A long time ago I received the following advice: only use "double" cubes. Loading values between int and double, or single and double types could be buggy and fail unexpectedly. Is this still advice we should be following? I have been creating all my numeric cubes as double types, even the matrix cubes that are always…
-
Monthly Customer News Update - February 2024
If you are not receiving our monthly newsletter, please let us know and we're happy to add you to the subscription list. The beginning of the year always seems to move fast with new projects, kick-off meetings, and more. We hope you can steal a few quiet minutes to enjoy the February newsletter. Here are some…
-
Data view formatting
Hi, I want to format the heading of a Dataview and a I don't find how to do it: I want to get all the blue headings from the below screenshot in green. I have tried to do it through the Block Format but I could only modify what it already appears in green. And I also tried to do it thought the Templates but I could only…
-
Unexpected behavior when setting up database security
Hi, We are trying out a new database security setup at a client. For now, we are adding security on one hierarchy, cost center lv0-3. Our security cube has the Lv0 entity, and has user. In the custom selection script, we have Select User = @User. This ensures that the system always only looks at the security set for that…
-
Data flow: Copy cube down to a more granular one
Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one. The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be…
-
How to update GCR version (1.0.1 vs 1.0.2)
1. Abstract As you may know, in Q2 2023 the first version of GCR, the new Board Solution to manage Financial Consolidation has been released. Since then, the development of the solution is not finished, and new patch releases will be frequently released. The goal of this document is to guide how to update your current GCR…
-
How to update GCR version (1.0.0 vs 1.0.2)
1. Abstract As you may know, in Q2 2023 the first version of GCR, the new Board Solution to manage Financial Consolidation has been released. Since then, the development of the solution is not finished, and new patch releases will be frequently released. The goal of this document is to provide guidance on how to update…
-
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?
-
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…
-
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?
-
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.
-
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 😉
-
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: https://help.theobald-software.com/en/board-connector/ In 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…
-
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?