-
Topic Thought Starters
There are many topics of interest to the Board Community. With a goal of expanding member's Board practice through thoughtful knowledge sharing from real-life example of Board in action—we welcome all ideas and can work together to refine topics. Getting started is often the hardest part! What should I write about? What do…
-
Meet the Q2 Community Captains
Here's a brief overview of our Captains: Bart Scott is a founding Partner of CFO Solutions LLC. He is disciplined in establishing the underlying structures that support end-to-end business intelligence solutions. From sizing and planning infrastructure to implementing integrations and data staging, Bart helps clients…
-
Multiple Down/Sub Total Rows in a single Data View
Dear Community, I would like to propose the addition of multiple sub/down total rows in a single data view. It would allow for not only a sum row at the bottom of each data set but also an Average row or other analytical calculations that summarize the data. This would give users a more detailed and versatile summary of…
-
Drill Anywhere configuration on block in layout in 14.1
Hi, I must be missing where it change in the UX but I can't find how to do the same option as bellow in 14.1 I can find the option for same tab or for Dynamic screen? And my test capsule I've migrated has lost the screen it was referring to and everything is pointing to home.
-
Historicisation of relationships
1. Abstract In Board, hierarchies are without time reference as standard. This simplifies data modeling in many cases. In some cases, however, it is necessary to map relationships between different nodes in a time-dependent manner and thus to historicize the values. There are different methods for this, which are to be…
-
Board Academy launches 3 short modules about the new features in Board 14
Board Academy is excited to launch modules about each of the 3 new features found in the updated version, Board 14: Layout Editor, Quick Layout, and Flex Grid. Each short module includes an overview of the feature and a step-by-step exercise, with video and written instructions, for a financial use case. Within the video…
-
Level 200 202 unable to view capsules and data model
Please can you provide the capsules and data model in an alternative format as I am unable to access the files from the Board Training Environment and unable to progress through the course. Thank you
-
User Locked Out Time
How long are accounts locked out for by default?
-
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…