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.
-
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
-
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…
-
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…
-
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,…
-
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.
-
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]
-
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
-
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…
-
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…
-
Flex Grid Configuration Issues : Locked Cells and By Column properties issues.
Hi everyone, I'm trying to recreate the Flex Grid layout shown in the screenshot (I've hidden the cube names, hopefully that's not an issue). In Cube 3 (Block C), I enabled Data Entry and set Detail By = Column: Month. Data entry is locked by Condition Block G, which is an algorithm also configured by Month. Due to the…
-
Error when using a data reader called via ODBC SQL Server Driver in a board procedure
Hi everyone, I don't understand why I'm getting various error messages in the log files of a procedure when I access our SQL Server using a DataReader. Here is a detailed description of the problem: Errors are being written to the log files even though the data reader is reading the data correctly. The error does not occur…
-
Conditional formatting of data labels in the Waterfall Chart Object
Hi everyone, I'm working with the Waterfall Chart Object and I'm trying to apply conditional formatting to the data labels (the values displayed above each bar). My goal is the following: Positive values → label displayed in green Negative values → label displayed in red For example: +200 → Green label+180 → Green label+30…
-
How to calculate the data among the entity members of same entity
i have a entity called "Test" members of its entity are Test1, Test2, Test3, Test4 Now i need to do a calculation such that Test1+Test2-Test3 and store this value against Test4. can you please help me in this. Thank you for support
-
Cartesian bar chart, bars move too far away from the x-axis when there's a slight negative number
The negative amount in this case, is that tiny green sliver in FY22, FY23, and FY24… but it moves everything so far away from the x-axis that it looks jarring. I can't find a workaround here that will be dynamic for several users, using the same screen.
-
Substitution formulas in column headers are inconsistent, and break sometimes. cannot figure out why
Here are some examples: In the main layout this works fine, but in a drilldown, the substitution formulas break. Here's another example: "@Version total" should be "FY26 Forecast (Apr) total", but I have other screens where I have the same setup, but it totally works If I can at least understand why it breaks, I might be…
-
Will the board still load rows into the cubes if the entities have NULL values ?
Hi everyone, I'm currently facing a problem where some rows can't be loaded into the cubes. Some rows are loaded without any issues, but others are not. For example, rows where the entity is_productive = 1 are loaded into the cube, but rows where is_productive = 0 are not loaded at all. One important detail: for the rows…
-
Show Groups as unbalanced Hierarchy
Hello Friends, I understand we have a limitation on Board where when we use Show Groups as unbalanced Hierarchy as below,it will not show the level one if level 2 entity has only 1 member My P&L has 2 levels , was using the "Show Groups as unbalanced Hierarchy" for Totals, but unfortunately i have other members in level 1…
-
Month entity without year
Hi, I'm using a dataview for sales analysis. On the rows I have the year entity. I need to put the month on the columns, to get 12 columns of data (1 for each month). If I use the Month entity I get one column for each month of each year. My Year entity has 5 years, so I get 60 columns. Can the month name be extracted from…
-
Missing alignment of the legend in the cartesian chart
Hi Team, Initially, I have cartesian chart with single data block. Then the alignment is fine. Now due to requirement change I have to add another block despite it is hidden. The alignment of the names is not matching with the icons in the legend. Could anyone please help me to fix this issue. Thanks & Regards, Vanam Pavan…
