-
level300､Module306:When executing [Defining Database Security Profile Cube Visibility],
When I executed the steps of [Defining Database Security Profile Cube Visibility], I couldn't input. It became disabled. If I hadn't executed the steps of [Defining Database Security Profile Cube Visibility], I could input. Please tell me how to input after executing the steps of [Defining Database Security Profile Cube…
-
Vertical % on Dataview
Hi, can I somehow use vertical % ignoring subtotals on a dataview? Thanks
-
About data view color settings
Hello I would like the text color to be red if the value in the data view is negative, and black if it is greater than or equal to 0.With the settings in the attached image, the 0 character color is gray instead of black, and the negative numbers are also light red and dark red. Ideally, I would like to display numbers…
-
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…
-
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…
-
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
-
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…
-
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…
-
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"…