-
How to change the Time range in GCR
1. Abstract In every Board application, the definition of the time range becomes very important because it guides the data that will be loaded and made visible to the end user. Changing the Time Range during the implementation will require several steps in a specific order. This topic has been already explained in a…
-
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
-
'Continue on Error' checkbox for Rest API Calls
Hi, with Rest API Calls getting more and more important and part of our solutions, an option to enable a procedure to continue on error would be appreciated. Right now, if the API Call fails (e.g. if if the call limit is exceeded or there are too many parellel calls), the procedure simply aborts and everything after is not…
-
Use Cube groups for Cube Visibility settings
Hi, Cube visibility is a great feature that we are starting to implement with customers. However, the setup of every single cube is a very time-consuming and maintenance-heavy operation especially in larger databases with hundreds of cubes. One tool that would greatly help in that area would be the possibility to set up…
-
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…
-
Paste image in support ticket
Hello, Currently, the support ticket does not allow to paste an image directly in the form. We have to copy the image to Paint (or other tools) and save the file and then upload it to the ticket. It would be quite efficient if we can just paste the screenshots directly instead of attachment. Most of the times we have to…
-
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
-
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