-
Board Office Add-In no longer works
Hi, for one Board user we had installed the Office Add-In 12.5 and that worked. The Board tab was visible in Excel. But from one day to the next the Board tab disappeared from Excel. I uninstalled and reinstalled the Office Add-In, but the Board tab no longer appears in Excel. However, it was working until recently. What…
-
Excel AddIn Documentation
Hi Boardies We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible. The problem is following: A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should…
-
Is it possible to add a "+" symbol in front of positive values?
Using the image above as an example, is it possible to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? (as this is requested in multiple views) I understand it's possible to add a prefix in block formatting however that wouldn't recognise a value as <>0 so it would place a"+"…
-
How to also export the Layout settings to Microsoft Excel Workbook for BOARD Add-in?
Hi, I am currently exporting data from my report directly into excel. I can then connect my Board office add-in to the table and apply selections and everything possible using the office conector. The problem that I am having is the value formats. In my report in Board (online) I have parenthesis instead of the minus…
-
NEXEL - Send Summary Results To...
NEXEL has a function labeled Send Summary Results To:. See the last line of here. Has anyone had any luck with this functionality? How about NEXEL Crossview? nexel
-
How to convert Board tickbox to a flag in Excel
Does anyone know how we can convert the tickbox column from an xlsx file into a binary flag? When I make column b = a, I get the same whether the column is empty or not. A user exported the file so I'm not sure if they can enter the layout to change the column appearance. Thanks
-
Appearance of inline buttons in dataview on the web
Anyone has an idea how to make inline buttons on the web look like "real" buttons? Unfortunately the web version does not allow to have gradient colors on the custom block formatting. This is what I used in the past to create a 3D effect. Without that, the button looks like a regular text field and it's often hard for the…
-
Mail subscription
Dear Community We have a case where the user does not see any subscriptions under "Show all subscriptions", but he still receives a mail with a pdf. attachement every day. Where do I have (as an administrator) an overview of all subscriptions created? Thank you in advance for your help Regards, Oliver
-
users in permission groups
Hello, I've added an user in a permission group that I'm testing but I don't see any way for removing the user from the group. I'am an admin on the platform. Did you encounter this situation ? thank you, Catalina
-
Server Installer tries to install .NET Framework which is already installed
Hello, I'm trying to install Board 10.7 server on an airgapped server (so it can't connect to the internet during the install process to download .NET framework). We've used the offline installer for 4.8 .net framework, and after some mucking around we seem to have it installed (at least going on the the registry entries).…
-
% of total
How to calculate Value/(total value in column), % ------------------------------ Vasily Feofanov Analyst Limited Liability Company "Super Brands" Russian Federation ------------------------------
-
Board manual
Why is it that if i wan't to read about a specific feature (how something works) i need to read it at the release notes and not in the actual manual?
-
Default setting for Relationship
Hello, When there's a parent missing to a child, the Default button becomes visible. But if there are no errors, you won't see the button. Is it possible to set the Default mapping for each Relationship from somewhere else, even if there's nothing missing at the moment? Thank you
-
Hochrechnung der Umsätze
Darf ich hier die Frage stellen, wie ich anhand eines Screenergebnisses einer Datenview automatisiert hochrechnen lassen kann? Ist sowas möglich oder nur wenn ich es ins Excel bringe?
-
Missing child in Relationships
Hi, I'm trying to create a dashboard on ESG Net Zero Emission. I've picked only a particular worksheet (1a_RM_&_pack_calc_1.csv) and created entities and built relationships for them, but after running the Data Reader, I'm getting an error on Missing Child in relationships. Thanks & Regards, Kranthikumar Goli.
-
How to read dataframes from R back in Board
Hi! I am struggling to use the R calculation step. What I am trying to achieve is to read back the "output_dataframe", defined in the R script, into a Cube. It is annoying since Board keeps on signaling the R DataFrame is incorrect (marked as red) even if not log statement is displayed, so I am not able to save it and…
-
Custom Entity Relationships in Time Range
Are Custom Entities only working as a parent to the lowest level? I'm struggling with the "Current Fiscal Year" (red mark). In selection phases (i.e. a screen selection), the selection of the entity member "Current" on the "Current Fiscal Year" won't apply on the child "Fiscal Year" (member "22/23" in this case). However,…
-
How to manage cloud tasks from on premise server - Orchestrator
Hello community i'm going to move to cloud and I know it's now possible execute a board procedure through an API call. Since I have various tasks to copy files to/from the cloud, to be synchronyzed with Board procedures, I would evaluate possible solutions to manage processes that combines batches to transfer files (with…
-
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…
-
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…
-
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,…
-
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?
-
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…
