-
Level 200, Module 204: Functional Test of the Solution
All my values are duplicated when comparing my Board instance vs the view that should be correct when reviewing the functional test of the solution. I have tried all the steps suggested to check my build, but I cannot spot the issue?
-
How to create a variance on one cube detailed by version
Hi, I am trying to create a variance column based on one cube that is detailed by version. The problem that we have is we have data in one cube by different versions. We have to create a report to compare versions together but we must be able to select any versions which means I cannot create a block reference on teh cubes…
-
How to create Line Chart based on a category AVE value?
Hi Board Team, I have created a table like following. I collapsed the table so I can see the Row Total only, which is calculated based on Product AVE. When I use a table with a category, it is by Row by Channel L4 and Product. So, it is calculated at each row first, then make the average from each row calculation. If I add…
-
"Timeout expired" error when running a procedure comprising of "Bulk insert to SQL Table" step.
Hi all, I am trying to carry out Bulk insert to SQL Table , but I keep getting a "timeout expired" error message. Here are some details about my setup: I am running this procedure on a Board cloud server which also has SQL database connection set-up. I'm using Microsoft SQL Server. I got the error as shown below in SQL…
-
Earn advocacy points at a Board Beyond event near you
The Board Beyond 2024 Roadshow is underway and we’re excited to invite you along. Board Beyond Roadshow Join fellow innovators, leaders, and a fast-growing community to see where Board Intelligent Planning takes your business in 2024 and beyond. With 7 cities confirmed and more to come, we think you’ll find the perfect…
-
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…