-
Community Roundup: April 2024
The Community team is back and excited to share with you the new features we've launched and the accomplishments we've achieved since December! From new tools, to streamlining navigation, to Community member outreach; we've had a busy period of growth and evolution. Some of the new features and Community accomplishments…
-
[Board 12.5.1.1] - Datagridview Nexel convert string to date
Hello, does this type of formula work into datagriview? =TEXT([@b;*;*],"d/MM/yyyy")
-
Just for Fun: Keeping Your New Year's Resolutions
Hello, Community! As Q1 is quickly wrapping up, it seems like a good time to do a self check-in. Spring has sprung (even if the weather in your area doesn't yet reflect it!), vacation season is near, and you may—or may not— be making good progress on those pesky new year's resolutions. No matter what you call them, setting…
-
Level 200: Cannot access the board training environment model
Hello, I'm currently in the process of the level 200 program but when I try to log in to the board training environment model it keeps refreshing the page. In the browser I can see it constantly (every half second or so) it refreshes and changes the sign-in callback code. Do I need to change anything so I can log in to the…
-
How to change the Time range in GCR/FCR
*** The entire approach described in this article is valid also for FCR application. FCR represents the natural evolution of GCR - rebuilt on the latest Board Platform with an optimized UX/UI to provide access to the latest financial consolidation capabilities. *** 1. Abstract In every Board application, the definition of…
-
Level 300, Module 303: incorrect result of the functional test
Hi, while doing module 303 I faced the problem of not passing the first functional test because after initialising the budget and 3+9 forecast I got the wrong numbers. After digging down the problem, it seems the data model procedure PLN - Initialise planning doesn't work correctly. I think that in this procedure at step…
-
Level 300, Module 304: Find How many hour it takes to have an answer
-
Monthly Customer News Update - March 2024
We've been busy making plans to continuously empower customers and help them succeed faster—plans that include the 2024 Board Beyond roadshow. Here's what we have lined up for you in this month's newsletter: Stay tuned for the upcoming launch of Board 14 Read how Kirin aligned 6 business companies in less than 6 months…
-
Comparison between different versions or scenarios in the same report
1. Abstract During the implementation of any application, a typical request is to combine multi-scenario or multi-version information in the same view to promote delta analysis and quick data comparison. Board plays an important role due to its flexibility and allows a solution to be achieved in several ways to provide the…
-
Default Landing Page
Hi Community, Is there a way to default users to a specified screen on opening rather than the default capsule view? Thanks in advance. ☺️ Jon
-
Level 300 Module 303: Incorrect and contradicting instructions on cube visibility?
Hi, In section "Defining Database Security Profile Cube Visibility" on module 303, I noticed that the step-by-step instructions on defining cube visibility are contradicting the overall instructions and will cause incorrect result in the functional test. In more detail, the step-by-step instructs to grant cell access to…
-
About Grand Total
Q1. I want to change the notation of grand total to, for example, total year. Is there any way? (Yellow part) Q2. Can I apply the rule to Grand Total? (Green part) Now, I have set the following rules. c=(b/a)%, f=(e/d)% I want to set the same rules for grand total, as shown below. i=(h/g)%
-
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
-
[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…
-
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…
-
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? https://academy.board.com/build-a-board-series 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) : https://community.board.com/discussion/16889/how-to-manage-mapping-data-entry 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…
-
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.