Platform Q&A
This forum is dedicated to Board platform questions, generally applicable to all members.
Please select 'Yes' if a response answers your question to better identify possible resolutions.
-
Filter Dataview to show only members with PDF file
Hi, I am trying to only show the entity members with PDF files available in a dataview. I've tried all available "IS____" functions but none is working. Is there a function that can help me filter out members without available file?
-
Printable Report Export Not Working in Board 14.3
Hello everyone, We are experiencing some difficulties when exporting a printable report in Board 14.3. I would like to create a PDF file, but unfortunately, when I select "Export Printable Report" > "PDF" from the top menu, the configuration window does not appear and the screen freezes. All I can see is a loading…
-
How to reduce the Icon size of On-Screen Tips?
Hi Board Team, Just a quick question about the On-Screen Tips icon. How can I make the icon smaller? I've seen a smaller icon displayed on other screens, so I assume this option exists somewhere. Unfortunately, I can't find where to adjust the icon size in Version 14.5. Thanks a lot
-
Bug when configuring block drilldown in Object Settings of a dataview layout
I don't know how to raise a ticket, but there is a bug I encounter in ANY screen. Whenever I try to configure Drill to Screen within Object Settings → Column Appearance → Configure Drill → Drill to Screen, it keeps on freezing my screen. We are on Board 15.
-
Extracting Cube Structures, Entities (descriptions), Relationships and Procedures data
Hi Team, Is it possible to extract the meta data of cubes (its structure), all the available procedures (data model + capsule procedures) with the steps in the json or xml or any other format. How to extract it from the Board application?
-
Waterfall Chart with text cube in X - Axis
Hi Everyone, I need guidance on creating a dynamic day-level waterfall chart in Board. I have a cube storing daily cash data by Day and Business Unit, along with two additional cubes storing major movement amounts and commentary at the same level. The requirement is to dynamically display the movement commentary along with…
-
Decimal values are incorrectly processed in text algorithms
Hi, I need to lock/unlock the data entry based on configured thresholds, therefore I need to work with decimals (stored in a cube) in text algorithms (input data validation rules for data entry in data views), but this leads to problems, because they are incorrectly processed and because of that its not working - see…
-
How to display calculated TOTAL row value in a Label
Hello, when I copy the following data view into a label, the label shows -100 instead of the aggregated TOTAL result (-13.64%). Current Month and Previous Month values are generated using month selection flags, so I need the aggregation on month level. How can I display the TOTAL value (-13.64%) inside a label?
-
Restricting the disabling of sorting on column in flexgrid
Hi Team, I have a flex grid object, there i am using a multiple sorting on it, If i click once, it changes to ascending order ↑ If i click again, it changes to descending order ↓ If i click it again, it removes the sorting order. it exceeding the no. of clicks so, here customer don't want to remove the sorting on the…
-
Lock column totals
Hello , I have a dataview in data entry mode. However, i would like to lock the column totals Anybody has a solution for me. Thanks
-
How to subtract two totals from different layouts?
Hi all, I am currently working on a report/dashboard and need help with a calculation.I want to subtract a total value found in one layout from a total value in a completely different layout. Could you please guide me on how to achieve this? Kind regards, Adam
-
Advice needed on how to manage 2 reporting periods in a Board application
Hi everyone, We have the following situation. Our client has multiple companies, 2 companies have the reporting period from February until January, and the 3rd company has a regular reporting period, from January until December. Currently, we set up 2 Timelines (entity called Cluster Timeline) and it appears in the master…
-
e-mail subscription error
Good morning Since a while the e-mail subscription tool is not working anymore for anyone on my company Board Platform. The page couldn't be open and the subscriptions are not working anymore. Trying to access it gives back the unhandled error that follows: at…
-
Hide Total Column or Grand Total Column in Data Views
Hi, I’d like to hide the “Grand Total” column on a screen. The sum across multiple years doesn’t make sense. Unfortunately, I haven’t found anything so far that helps me with this. Some of my colleagues have also encountered this use case in other projects and were unable to resolve it. Can you help us? More details are…
-
How can I correctly display a revenue ratio?
How can I correctly display a revenue ratio (costs as a percentage of of revenue) in Board?No matter what I've tried so far, as soon as I have row and column totals, the ratios for the totals are not displayed correctly. I used a cube without an account entity, into which I only wrote the revenue. I used the original cube…
-
Data reader - new master data members got an arrow as a prefix
Hi everyone, I built a data reader that pulls master data from SAP and when I ran it last time new records got this prefix, either 1 or 2 arrows. Can anyone advice on how to fix this? Should I clear the entire entity and try again or do something else?
-
Calculating the Row Total
Hi all, Is it possible to get the row total of an algorithm data block? When I use the rt() formula for data block d (see table below), it seems it's getting the total first of the factors before multiplying them instead of just summing up the result per month. Layout Row: Client Column: Month Data Block Data a Value b FX…
-
Can I have an alert on both the block and the figures?
Wanting to have the block change to a light red while the figures go dark red when the numbers go negative.
-
Charts - Labels
Hi, I have a waterfall chart. How can I make my negative variances formatted in parentheses? For example, -5 would be (5). Thanks, Chris
-
Dynamic Map Legend Based on KPI Range
Hi everyone, We're looking for a way to generate map legend ranges dynamically based on the actual KPI values displayed on a Board map. The KPI is a calculated metric used in the map. The goal is to determine the minimum and maximum KPI values across all displayed territories and automatically create 5 equal classes for…