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.
-
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…
-
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…
-
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…
-
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
-
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…
-
Cube Extract Error
Hi Anyone an idea what that means or where i could look up error codes? The procedure failed while executing: 2. Extract cube Comments: Object reference not set to an instance of an object. [CorrelationID: 9b8f6632-92c7-4c03-bfb0-73f4b7d1663e]
-
How to display the unbalanced hierarchy in the collapsed view in the dataview?
Hello Board Team, A client has an Account entity set up as Unbalanced Hierarchy. They have a simple dataview with 1 block using a cube with actuals, and they want to display Account entity in rows in a collapsed view: e.g. to show "+ 1P SVOD line" by default, and when end-users click on it, 3 revenue sales lines show up,…
-
Do datapickers work with fiscal offsets?
I have a datapicker that references a cube that stores diluted shares by fiscal Year. When I try to do a trended P&L, where I duplicate the P&L cube and apply time functions for previous years, everything works except for the datapicker row, even though the cube it's pulling from is dimensioned by the appropriate fiscal…
-
Dynawrite, the user clicks W, DOWNLOAD, the 'Oh no!' error appears
I am tired of seeing this bloke changing the lightbulb. Can anyone provide a solution? The user clicks the W, the pop up appears, they click DOWNLOAD. Next the 'Oh no' message appears. HORRIBLE WORKAROUND: In the pop up, click MORE. Deselect a Dynawrite object (but you don't know which one so you must do this several times…
-
Board 15. Integration Board Cloud with Microsoft Fabric
I read a post in this community related to connection of Board on premise to Microsoft fabric. I've intended that there is no data store in Cloud connector that allows you to connect Board natively to Fabric. What could be the best method to use? We need to read from Fabric and write back to it.
-
Dynamic File Name based on Entity Member.
Hi Guys, I am exporting a layout to the server, and I need the output file name to be dynamic based on the selected entity member in the procedure. For example: If the Data Category is Entity and the selected member is Actuals, The generated file name should be: Actuals_Report.csv Could anyone guide me on how to achieve…
-
Master Layout selection - Substitution formula
Hi I have screen with multiple tabs. I made a selection on the Master Layout and all other tabs / layouts adjust to my selection. Is it possible to show in a label what i have selected? similar to substitution formulas? Thanks Maik
-
Detail by Month, adjoining blocks
So this is my desired output in terms of how the columns are ordered. By MONTH: Actuals Forecast Variance I tried seemingly every which way to get this achieved result, and the only way that "almost" works is doing detail by for all 3 blocks, but adding "order" and keep top 3, for all 3 blocks. But ascending in this…