-
Announcing the Community Weekly Email Digest
The Board Community team is excited to announce the launch of the weekly email digest feature! The email digest feature automatically sends weekly email messages of "personalized content" to subscribers of categories and contains summaries of and links to top trending community posts (discussions, comments, questions,…
-
Zero values in charts
Dear Community I have a chart with development of KPI over months. The user has the possibility to select different years. The Serie is plotted as a line. Now I have the problem, that when the values of past years is zero, the line has a break in between and the chart is strange. so I want to deactivate the "zero value"…
-
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
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…