-
Dataflow mode question (206)
hi - I am working through the L200 course. In 206 / Knowledge Check, there is the question: "What is the purpose of the clear cube step of the BUD - Initialise Budget Procedure?". The course's own correct answer is "The mapping mode on the Cube is set to ADD, which will cause the data to increase each time the procedure is…
-
How to design screens & dashboarding
1. Abstract Screen and dashboard design can at times make or break an application – if screens are poorly designed or unintuitive user engagement can be compromised from the off. There are many factors to consider when determining what constitutes a good design - from layout and ease of navigation to the amount of content…
-
Level 200, Module 205: Sales Planning Procedure
Level 200, Module 205: Sales Planning Procedure ACT - Sales Data Load Data Model Procedure Step: 4 Select "CALCULATION DOMAIN" and in the Extend calculation on new tuple for all members of section, select: "Country" and "Timestamp". Why are we extending the calculation? I am aware that it will open the dense cube dimension…
-
Board 12.6.0.1 : The JOIN function is not supported anymore
Hello, In Patch 12.6.0.1, as per the release notes : Dataflow : The JOIN function is not supported anymore and should not be used in the Dataflow configurations ⇒ Could you please explain if there is a change in the code related to JOIN() function : All dataflow with join() will now fail ? or it is for information purposes…
-
Community Roundup: August 17, 2023
The Community team is back and excited to share with you the new features we've launched and the accomplishments we've enjoyed in the last six weeks! From new tools, to streamlining navigation, to Community member outreach; we've had a busy six weeks of growth and evolution. The new features and Community accomplishments…
-
IBCS Standards
I would like to suggest to enrich the dataview and graph settings to help building a BOARD application using reporting standards as suggested by the IBCS® standards (International Business Communication Standards). These standards aim at providing a consistent reporting set for the user, so that he can very quickly know…
-
Measure Totals in Data View: Force to be a sum
Hello Community, I am running an issue with the total value in a data view and wondering if there is an easy way to solve it. I have an example below I want to calculate the $ impact on price difference (column K). For individual row the calculation is correct, not saying the total is wrong but I just want to force the…
-
Best Practices in Writing Procedures
1. Abstract Most probably every Board application will have procedures to cover interactivity by the user (e.g., navigation), perform calculations (e.g., processing plan data) or run other backend processes like creating a backup. To provide the best maintainability, quality, and robustness, some guidelines should be…
-
Level 200, Module 204
I'm at the mapping stage of H - Product Data Reader, and I can only drag the first item over and save. The remaining items (for product, product group, product category) 'bounce back' every time I try to bring them over. Wondering if anybody else is experiencing this.
-
Admin portal scheduled procedure error message
This error seems to be the default when a procedure scheduled from the admin portal fails. Would be useful if the error message was more descriptive of the error.
-
Anyone using version / code management software in BOARD projects?
Hey community, I just saw Bob Gill linking his article World Cup 2018 to a repository on GitHub (GitHub - grobertgill/Tournament: BOARD Tournament model setup for World Cup 2018 ). This is something I have been thinking about now and then but have never tried to do. Is anyone of you using such solutions (GitHub, Subersion,…
-
Overview ApiQuery calls (# of requests) in Cloud Administration Portal
Hi all, it would be wonderful to have an overview in the cloud admin portal how many API requests you actually use per day. Since there is a limit of 500 requests per day, this would help the customer understand if they need to think about increasing the limit soon. Thanks a lot!
-
Community Voices: Nicolas CHIGROS
We are excited to bring you more valuable insights from the ‘Community Voices’ series! This month, we welcome Nicolas CHIGROS—a long-time Board user from Kiwika, an EPM-specialized company and consulting partner located in France. You’ll find Nicolas active in the Board Community participating in opportunities like the…
-
Formatting options for Menu object
In order to make Board applications even more beautiful many POCs or pre-sales demos make elaborate use of labels to create a menu that gives the user the feel of workflow. See below example. If the menu object had some abilities to configure the style and formatting this could concievably be done with the menu object.…
-
How to move columns in Reports?
Hi, I need to build a report where the row entity is in the second column. So in essence I need to show actuals data then the row entity then the rest of the columns. What I have tried was to bring in the row entity into the layout section of the report but noe any template styling is not applied to the entity. See the…
-
Format individual cells
Dear All, I have a question regarding formatting individual cells, is it possible to color a individual cell eg. if value is negative → green, if value is positive → red. I know the option color alert, but this has effect on the total column. Is it possible to format individual values in a row/column? Regards, Wouter
-
Color fade away in the Data View
Hi, anyone know how to turn off the color fader for the alerts in the Data view? Want to add some colors to the variances but noticed that the colors seems to fade away based on the value (example below). I just want the negative values to be static red and positives to be static green.
-
Board and SOAP APIs
One of our APIs that customer requires a connection to does not have a REST API, but only a SOAP interface. I know that I can connect to this using PowerShell, but does any Board expert have any suggestions or recommendations as to the best way to get Board to interact with a SOAP API?
-
Cloud Hosts- Planned Maintenance Schedules
Scheduled maintenance for OS level updates takes place on a fixed Sunday of each month on each Board Cloud instance (unless otherwise communicated by Board). Details of the schedules can be found here. Currently, details of this window are not displayed to administrator users anywhere within the platform which can often…
-
Extract/Import Trees Unsorted
Hello, I'm sure any admin of BOARD has faced the issue needing to refresh Development Cubes/Entities with new info from Production. I'm sad to say that this process is FAR less straightforward than it would seem. It is very frustrating to always have to follow the steps of : A) Remove all sorting of entities (Production)…
-
Moving Data
1. Abstract Often customers’ requirements are to copy data from one element to another. Typical examples are copy processes from one version to another or to copy data from an existing reference product to a newly created product as an initialization. The calculation logic in those examples is the same and can be applied…
-
Using Unbalanced Hierarchy and standard entity together
I have an unbalanced hierarchy ( P&L Reporting) which has multi-levels Level 1 — Level2 — — Level 3 Another entity is Account which has all the base-level accounts in it. Level 3 of the unbalanced hierarchy is linked to the Account entity where multiple accounts have a relationship with a single Level 3 member. I have a…
-
Unbalanced Hierarchy broken?
Good Morning :) I have an entity which is an unbalanced hierarchy. The entity seems fine. Here are the settings: I also have a SQL Data Reader which loads the Entity and the Relationship which also seems fine: The Data Reader runs just fine. No error logs, no cancellation. However, the relationships are not built. I have…
-
Entity Broken?
Good Morning :) I have an Entity that seems fine in the DataModel: However, if I look into a DataView in a Screen, there are no values in the entity. (even with show all, nothing is shown) What could be the problem? Thank you Kind Regards Wolfgang
-
Documentation EXCEL-ADD-IN
So, I'm about to take a closer look at the EXCEL-ADD-IN from Board. At first sight what's offered is rather disappointing! A handful of more or less powerful VBA functions, I could live with that, then I build them myself. My "old" MIK software already had much more to offer. And that was more than 15 years ago! But what…
-
New feature in 12.6 - Permission Groups
After a recent upgrade to 12.6.0, some users were not able to log in, getting an error message "Error. Sorry, there was an error : unauthorized_client. Request Id: 0HMSA0GDGEDP2:0000003C". It didn´t happen to the users with Admin license. So we´ve realized that in the Subscription Hub there was a new setting which was…
-
Do not replicate entities when we flatten the entities by row
When we have multiple entities by row and we flatten at a certain level, we would like not to replicate the members of an entity and merge the cells with this entity, as in the image attached.
-
Apologies for the Board Education Invite!
On Friday, July 28, 2023, an invite (sample below) was erroneously sent out to all customer and partner users that have access to the Board Academy asking them to join the Board Education site (for Board employees only). We apologize for this email and ask that you kindly disregard it. Please continue using the Board…
-
Board12 Add-In Office WebApi Login error
Hi, I'm trying to connect to an on-prem Board 12 server using SAML authentication via WebApi. In the connection configurations I entered "https://myserver.com/" as hostname and I selected SAML. When I try to connect (using Excel) the browser opens regularly on the login page, I enter the credentials and the browser…
-
Impact Analysis update of information
Good morning, Our team would like to know if there's a method to update the impact analysis information. We have verified some cases where a name of a procedure or a screen is changed manually but this is not reflected in the impact analysis, which still shows the previous name. We believe having seen this for other…