-
Monthly Customer News Update - April 2024
Breaking news of April: Michelin, the world’s leading tire company, has shared how it uses Board to transform performance management planning. Board Beyond is now underway, so be sure to reserve your seat. You’ll hear innovative customers from SWIM USA, Groupe SEB, Colnago, and more. And the Board 14 release is only a few…
-
Showing Total year and ytd values on same screen
I want to create a capsule screen where the user can see total year sales for prior years along side the previous month year to date sales for prior years. I can easily get the total year sales by pulling in a reporting cube by year, and detailing the block by year. I am struggling on the best way to get the previous month…
-
Are you new here? Join us in the New Community Members Group!
Welcome new Community members! In our quest to continuously improve the Community experience, we're excited to announce today's launch of the New Community Members Group. Hit the ground running by learning more about the Board Community's purpose, various spaces, house rules, key topics and more while also building…
-
Formulae and Formulae Tracking / Lineage
Hi there, Increasingly our customers and prospects are comparing some specific functionality that exists in Anaplan especially, when it comes to formulae in Board. There are TWO key areas: When using Rules (or Nexel), the references are not written in natural language. e.g. if you are writing a rule that takes Sales and…
-
Extension of dynamic selection
At the moment, the dynamic selection is based on one cube. So an element of an entity is selected if there is a value for this element in the cube and vice versa. In my opinion this functionality could be improved by: the user is able to create the condition (referring to one cube) himself, for example: if(x>3,1,0) the…
-
"Page By" Excel extracts
Useful to create separate tabs within Excel file for multiple "page by" options, but if we also need a consolidated view of report on a separate tab, this needs to be done as an independent task. Would it not make sense to have a tickbox to "include total/consolidated view" as a tab in same task?
-
Capsule Procedure vs Datamodel Procedure
1. Abstract While developers are facing procedure creation, they need to understand when it is appropriate to use data model procedures vs Capsule procedures. 2. Context As developers, it is our responsibility to always keep the long-term maintainability of our solutions in mind. Procedures must be developed in a…
-
Level 300, Module 302: Not able to move forward in Level 300 course in module 302
Under 302 module in Level 300 course. Stuck at "Functional test of the Solution". And also not able to tag Level 300 course in tags
-
Possiblility to hid an item in an entity
Dear Community The users of Board are asking if it’s possible to hid a item in a entity. Since it’s not possible to delete a item it would have been nice if we could hid them for the users. There are some “old” items that they do not want to show in the entity when they select items the screen. As Admin it would have been…
-
Level 200: Cannot access the board training environment
Hello, I repeatedly get the same error message when I try to load the Board Training Environment. Here is the error message: Error on deploying the environment, The orchestrator function 'CreateVMSubOrchestrator' failed: "Error on deploying course detailId:1317, vmname: a18-justfmtc, courseId:4". See the function execution…
-
Level 300, Module 302: Not able to move ahead in Functional test solution.
Not able to move ahead in Functional test solution under 302 Module. And also not able to tag #Level300: Building a Planning
-
Board Beyond - London: Exploring business transformation journeys
2024 is a jam packed year for the Board Beyond Roadshow with events scheduled for all over the world, the first taking place at the IET: Savoy Place in London where industry leaders and strategic planners gathered to explore business transformation journeys and share their best practices. A number of speakers and panels…
-
Show Currency/Unit of Measure next to values
we are having since years requirements that we want to show the currency next to a value or the unit of measure next to a quantity. e.g. Material xy —> purchasing order quantity 1.000 M (meters) No consultant was able to show me a solution so far. But I know this working in other tools (e.g. QlikView).
-
ALM - Merge Branch
At present, developers can only develop together on one MasterDB. This can lead to problems in large projects with many developers. Example: Developer 1 starts a procedure to calculate values in a cube. Developer 2 has to empty an entity that is contained in the above-mentioned cube. For example, because the MaxItem number…
-
How to see detailed Totals when you have two dimension on rows
Hi, We have a Dataview where we have two entities on rows: Region and RL, like follows: The Total row adds all the rows, which is OK for the region but has no sense for the RLs. Is there a way that I could have the Total region detailed by RL? Thanks
-
Retrieving the data model from Board into the Power BI
Hello ! Dear community, I would like to ask you about your experiense of retrieving the Board data model to use it after in Power BI. Because, as for now, in the Board manual, I've found the instructions about Power BI add-in, which allows to access to the Board Presentations only. Thank you in advance !
-
VBA integration with BOARD Using the Excel Add-in
Hello, I'm trying tu use VBA to automate a connection with the BOARD tab in Excel. I found a manual with macro code sample, but it doesn't work in my case… Sub DoConnect() Dim addin As Office.comaddin Dim automationObject As Object Set addin = Application.COMAddIns("BoardExcelAddIn") Set automationObject = addin.Object If…
-
V12 - Smart import & max items
Hello everyone, As a neophyte, I am currently experiencing a few problems. Indeed, most of my models are still on a pre-V12 version and I'd like to understand the advantages of the V12 on certain points. Optimization with Smart Import in Board V12: What are the best strategies for taking full advantage of the "smart…
-
How to manage the leap year in comparative analysis
1. Abstract In an application life cycle it is not unusual to come across leap year management, moreover when comparative analysis are put in place. Accurate handling of leap years ensures data consistency across different timeframes, preventing discrepancies when comparing results from different years or performing…
-
SVG-Icons for Entities
I suggest the possibility to add own SVG icons to entities. This makes it possible to display them instead of or in addition to code/description in selectors, diagrams and dataviews. This option is particularly interesting for grouping entities, workflow entities or other static entities. It is important that these can be…
-
Improvement of usage of BLOB cubes
Dear Community, We're using BLOB cubes to collect from our contributors various documents that they attach (i.e. upload) in .zip format. So far this feature is limited. We would love to be able to : Check the size of the .zip when the upload is done in order to block the upload in case the file is too heavy Get, in logs, a…
-
Impact Analysis - Data Lifecycle
If incorrect or no data is displayed in an existing report, a developer must find the cause. This can be very time-consuming, especially if the database is very large and or was developed by other colleagues. The aim of this feature is to support the developer in exactly this search. A first starting point is the impact…
-
UBH Extract Dataset - Behavior of Parent Level Selection
Hi Team, Having spoken to people in product already, I wanted to put this idea out there. Business Ask : Being able to pull data for a parent level on a UBH out on an export dataset Issue : Currently, Board has no way of being able to select a parent level member on a UBH and extract the aggregated sum of all its…
-
Naming Convention
1. Abstract The following document is intended to suggest and give concrete examples of the nomenclature to be used during the development of the back end and front end of a Board solution. The aim is to have a consistent and organized nomenclature that led to a maintainable solution that can be easily consulted in the…
-
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…