-
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…
-
Update Data changes Colours in carthesien objects
Hello everybody I have a week based report that is updated each tuesday with the previous week data. In the report itself it has a carthesien object showing the previous 7 weeks. The chosen Colour is "warm" (with yellow to red). Now when updateing the data and displaying the new week and the dismissing the week -8 the new…
-
Is there a way to transport Presentations from one server to another?
Hi, I'm trying to move presentations built in S3 to C2. The Data Model and Capsule has already been pushed to C2. How can I do the same for the Presentations? Or will I have to manually recreate these presentations?
-
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…
-
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
-
An unhandled error occurred (cod_ref: 1695366869500)
Hi, I found abnormals numbers in some input cells (see screenshot). And when I try to type a normal number I get this error message: An unhandled error occurred (cod_ref: 1695366869500) Does anybody know what does this mean? And how to correct the input? Thanks in advance
-
Nexel when transitioning to Web Capsules
Hi, I'm having an issue with existing Nexel layouts transitioning capsules from Client to Web (now on Board 10.7) - every time the procedure is ran (which includes 'Save data entry' step) Nexel doesn't save to the cube anymore (it only contains the values we prepopulate the cube with to give us a base). My current work…
-
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).…
-
Nexel won't write back to cubes on the web?
Hi, I have a layout using Nexel (with Allow Write Inplace highlighted) that commits data into a cube using a single rule. This works great in the client. However, on the web, it does not commit data to the cube when a "Save Data Entry" action is performed. Additionally, unlike in the client, the web does not even have the…
-
Translation : Having different german translation per country
Hello, We are using cube language feature for entity member translation with following language : EN / FR / DE Now, we have some country requirements to have german translation that should be different per country, eg: German for Switzerland German for Austria German for Germany Is-it possible ? regards julien
-
% 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,…
-
Dataview Layout: Impossible to apply a filter when an aggregation function is used
Hello community, I'm quite new here. if this is not the right place for this question, please redirect me. I have a Dataview layout in which I use an aggregation function to display the average value for my block along the time entity "Month". When I try to apply a filter to this layout, it has no effect. However, when I…
-
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.