-
Level 200 module 212 : Mapping not working properly
Hi the expenses data is loaded into the P&L Cube, but for the mapped Sales data , there is no entry. I guess I somehow messed up the mapping, but I can't find the error.. BUD - DF - Sales Cube + P&L Mapping Cube are not empty
-
Refresh (Add-in Excel)
Sometimes the refresh of the layout does not work properly. Some old data are not deleted and the reports is not visualized properly, without modifing filters or changing anything. A popup error appears asking to add some columns or rows to have enough space to visualize the report. It would be nice to have the refresh…
-
Copy/Paste on Layout for Data Entry
Data Entry: There is no possibility to do the copy/paste function on multi selection of rows and columns: the only results of this activity is the paste only in the first selected rows. It would be nice to have this feature to do the copy/paste on multiple lines/columns as it was possible in the previous version (Board 10)
-
Simultaneously of Sheet Seletion and Workbook Selection
Board Add-in Excel: in an excel file with multiple sheets it is not possible to set filters in workbook selection (e.g: year, scenario) valid for all sheets and filters on sheet selection (e.g: accounts) valid specifically for a single sheet. If both are used, only the sheet selection is considered in the file. It would be…
-
Function "Show Inactive Members" (Add-in Excel)
Board Add-in Excel: if there is an active selection of an entity and we need to add another one or more occurrencies, the function "show inactive members" is not available (see the attachment), and so we have to unselect all the occurrencies and select the new list. Would be nice to have this new feature with the new excel…
-
Object Formats Library/Bookmark
It would be nice have the capabity to save object formats in a library, similar to select bookmark. Adding an option in the copy/paste format drop down list that says "Save Format Bookmark" with also the capability to set a specific format as default for new objects (dataview, labels, etc…)
-
Rec Id on Log Files
Some log files, such as the mailer and data entry logs, have not a unique record id. This would be useful in structured analysis of logs. A counter would be enough.
-
SubHub : Sync to data model : add option to trigger a procedure
The idea is to be able to trigger a procedure per data model once the synchronisation of the entities and relationship are done. Often you need to do some calculation based on user Role or metadata to account for the changes, give him access to workflow he previously didn't have to. And at the moment you have to rely on…
-
[TECH] Dataflow concurrency in DB with a lot of users
Hello, I have a budgeting datamodel with 300 users (facility manager) where we are sometime facing DB crash / data loss. Since it is a budgeting model, we have a lof of dataflows launched by user to perform calculations. For an unknown reason sometime a BOARD is not able to complete a simple / basic dataflow, so the…
-
Public list of known bugs available for customers & partners
It would be useful have available in the manual or somewhere in support site a list of known bugs / problems / unwanted behaviours and a plan for fixing. This will save a lot of time and money! Sometime happen that some function is not working properly. I've recently spent more than 1 day + half day of ext consultant to…
-
Bulk Insert to SQL Table failed!
Hello, I tried running a basic procedure, with an initial selection and a bulk insert step. However, the procedure fails and gives this error: ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. Moreover, it does not recognize the fields in the SQL query. In the log file, all the fields are…
-
Smart Import Object
Smart Import Object Smart Import is a new screen object that allows you to define simplified, guided processes to import Excel datasets into Board. Whether you are an end-user or an advanced-level Board developer, this short course is designed to build your competence with this new object.
-
"pending data entry" - no alert upon re-opening screen with procedure
Hi, we found that with V12.6, coming from V10, there is no alert for "pending data entry" anymore, in case you re-open a screen using a procedure. Screen close and refresh (F5) is working in terms of producing this alert, but not opening it again via procedure. Is this a known issue and will that be fixed with V14? Thanks…
-
Level 200, Module 209
When I get to the functional test of the solution, and click on step 1 of load data, after selecting Italy, the data reader does not seem to work. However, when I created the label and clicked on it after selecting Italy it worked, I mean, before arriving to the functional test past everything was working fine. Please…
-
Extract and Reload Bookmarks by Users, in order to keep them after clearing and reloading Entities
I have this requirement on Bookmarks from a big account. They are happy to use bookmarks since it is a big upgrade in their daily work compared their previous solution. The big problem here is that they need to clear and reload their MD's because it's a FMCG companies so their MD's have a high rotation. When they do that…
-
Level 300, Module 304: How to access the Tips and tricks 2023?
Hi Board Academy support, In Level 300, Module 304, there is link to access the Tips and tricks 2023, however, this link redirects to a microsoft authentication page and it seems that this link is only for Board employees with a Board email address. How partners can get access to this? Thank you. Nicolas
-
Displaying revenue data for bissextile year with previous year function
Hello, I am facing a challenge with displaying revenue data for bissextile years when using a previous year function. We have a cube by day, and a screen selection on the current fiscal period (March2024-February2025), a dataview that shows the revenue for N and revenue for N-1 values. The issue regards the N-1 column on…
-
Announcing an enhanced search experience
The Community team is excited to share two new features to the Board Community search experience which will allow users to more easily drill down on topics they're interested in. Thanks to the use of tags filtering in results and the addition of the AND operator, you can now return results that have all the tags entered.…
-
Build-A-Board Capsules & Data Model
Hi Community Does anyone have the Capsules and Data Model for the Build-A-Board series on Board Academy? Thanks
-
Triggering a back end procedure on click
Hello, I have a data entry block through checkboxes. I would like trigger a back end procedure on click (said differently, when I select the checkbox). Another question is about the value when I select the checkbox, as my block as set up as Single, the value equals to 1 when selected and to NUL when unselected. Is there…
-
Matrix relationship SQL not working 🤔
Hello dear community, I want to do a matrix relationship via SQL datareader (same as explained in the resources below) : Here is a screen of the ETL : The result is an empty cube with no discard and "1" as a validated record Thank you in advance for your help
-
PRESENTATIONS FORMAT
Hello All in presentations, it would be great to be able to reformat the columns. To date, the columns retain the format of the original report, which severely limits the interest of the presentations. It would also be very useful to have the function available to flatten the data. Thanks for your attention
-
Entity editor
If you place the Entity Editor and the Data View on the same page, you will not be able to see the contents of the Data View. How do I put them on the same page?
-
Level 300, Module 306: Flag the indirect Cost Accounts
Dear Board Academy support team, In the module 306 of Level 300, it is requested to select Indirect Cost Accounts (as per the below screenshot) However, these accounts are not present in the account Entity. As requested prior to this step, I updated the account hierarchies by running the "H - Unbalanced Account Hierarchy"…
-
Level 200 Module 204 Unable to locate files
I am unable to locate files when I enter the C:\Board\Dataset\Hierarchies and Data in Path and *Product Trees*.csv in Pattern.
-
Tree Object
Hi BOARD Team, I created my first Tree Object. The Tree always auto resize itself to the centre of the canvas and make the tree looks small. Is it a way / settings I can force the tree enlarged to fill the canvas ? Thanks Harry
-
Time Conversion🤔
Hello Dear community 👋 In the ETL, how can i convert a date from this format for exemple : /Date(986083200000)/ to this format : 200104 Thank you in Advance 🙂
-
Switch versions
I want to switch from working to final version with just one tap on a label. Can someone suggest me for the same.
-
if-condition in a data entry reverse algorithm
Hi ALL, I would like to write in data entry a value in a column algorithm in the block c and based on the value of the block d I would like block a or block b to become equal to block c. To do this, I enabled data entry on blocks a, b and c. The algorithm in c is "if(d=0,a,b)", and tried entering as reverse algorithm…
-
[BOARD 12.5.1] - Max Entities per row into dataview
Hi, What is the max of Entities per row (par ligne) into a dataview?