-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Adding Blank Rows that Mesh with Block Format
Hello! I'm working to enhance our current P&L report to improve vertical readability. I'm doing this by adding "Blank" members to the entity used in the by row configuration underneath key metric milestones (ex: Total Rev, Total COS, GP, etc.) No problems there; However, the formatting is clashing with block format since…
-
Dynamic Selection on a Layout
Hello everybody, I'm using Board 14.1 and I have a question concerning the dynamic selection. I have 2 flex grid in 2 tabs on my screen and I would like to make a dynamic selection on these 2 flex grid. A dynamic selection on the screen is not an option because the dynamic selection for the 2 flex grid is different. Thank…
-
Entity Editor
Dear all, I would like to have an entity editor and a data view - where I enter assignments between the members of two entities using the data entry function - on the same screen. The entity members that are created in the entity editor should also appear on this data view. However, the problem is that only the members…
-
How block in layout display decimal value when tagged as Numeric vs Text
I am working on 14.2 and have come across a strange behaviour how the system is displaying decimal values when a block is tagged as Numeric vs Text. The Layout has YoY Change% displayed as 3 blocks, one is marked as Numeric while the other is marked as text. The block marked as text changes the decimal point to a comma.…
-
Saving @Selection_Ex() result
Hi all, We are working on new functionalities for cost allocations, where we will need to store the explicit selection made by the user. This selection can be done on 1, 2 or 3 different trees, containing up to 30 entities each. I don't want to store the resulting selection at the lowest level of the allocation driver…
-
How to disable on Alert formatting on Total row
Hi BOARD Team, I applied COLOR ALERT on a data block. It works fine on each row. However, it is impacting the number showing in the row total. Anyway I can force the row total as BLACK? Thanks
-
Expanding a column for a drilled Data View
Hi all, after drilling in the main Data View, I'm left with another Data View that has an "collapsed" column (screenshots below) If i manually expand the column and then save, once i go out the layout the column remain half hidden. I don't seem to find any option in the settings to expand the first column. How can i make…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
Extract layout
Hi all, i want to know if it is possible to extract a date cube A (dimension: Entity) on premise: into something like this in a txt or csv file. sv0001 20241107 1 My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture. P.S. I…
-
Filter Option in Layout
Has anyone encountered issues with the filter in the layout? I'm tryng to filter with min value >1 in some Cube value but report show all items also with zero value. Thanks
-
Dynamic Data View Block Headings?
Hi, I would like to ask everyone: what options do we have when we wish for dynamic headers in our data views? My client is still in Board12, but we have a Board14 upgrade planned for the near future. Specific issue: the client would like to have a report that has dynamic headers with regards to months and versions. There…
-
Hide blank records when Data Blocks alignment is Vertical
Hi Board Team, Normally, we will use the FILTER to hide blank records. But once I changed the Data Block ALIGNMENT to vertically, the filter is not working any more. How can I hide blank records when Data Block alignment is vertical? Thanks My Axis properties are NOT selected as Show all. Thanks a lot
-
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
How to apply Dynamic selection of yesterday to Layout Block?
Hi BOARD Team, BOARD system had a default entity for Day. How can I use procedure to make a dynamic selection of Yesterday and assign this selection to a Layout Block? Thanks
-
Custom drilldown layouts not working in B14
I've discovered that the newest version (14.1) appears to not preserve custom drilldown layouts in the same way that B12 did. In B12 I was able to "Drill anywhere" on a column and then edit the layout in the popup, which was very useful for displaying data which was otherwise too big for the original layout (comments,…