-
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
-
Binary Cube
Hello, there are many situation where a cube is used to "flag" a certain on/off condition (like SBO, dynamic select, matrix cubes, etc). In most cases people are using integer cubes for this (in B10 a integer cube was 2byte per cell, in b12 it is 8byte per cell). From application point of view one bit (so true or false) is…
-
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
-
Improve tracking of changes in procedures
Hello I propose adding a modification tracking feature to the "Procedure" functionality. Exemple : Procedure: [GEN] - [WOR] Sales revenue Creation Date: [Insert Date] Last Modification Date: [Insert Date] Modified By: [Insert User-Name] I welcome any feedback and discussion on this proposal.
-
Change default Cube Data type to "Double"
A couple of years ago, we were suggested by Board to always use Data type Double, instead of Single. However, the default data Type when creating a new Cube is Single. I would also assume Double is the most common Data Type used in Cubes. That makes it more relevant to show Double by default. Suggestion: Change the default…
-
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…
-
Dynamic Decimals on report views
Hi team! We've recently had two customers and a partner reach out about the request to dynamically show or not show decimal places. Right now, it currently requires work arounds that involve layout adjustments or duplicated screens. We would like to request the ability to adjust the decimals we are viewing on a report…
-
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…
-
Log recording when normalization settings are changed
At present, it is not possible to use log files to track changes in normalization settings. It would be desirable to be able to log changes to normalization settings.
-
Logging procedure changes
There are cases where we want to identify the user who deleted a procedure object and the time it was executed. It is desirable to have a function that can output such information to a log.
-
Log output for changes to the scheduler
At this time, changes to the scheduler are not tracked in log files. It would be better to improve it by recording it in a log file.
-
Horizontal Orientation for the Expander
Hi, it would be great, if there would be a option to set a horizontal orientation for the Expander object. You could use it to build a dynamic menu bar, where you could hide labels without leaving a gap between them.
-
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…
-
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,…