-
Dynamic Ranking with Details
Hello, I would like to display a dynamic ranking in a screen. For example, as a master dataview I have the countries with the Nexel RANK function and a selection on a time period. Next to it, a dataview with the customers from this country (also with a ranking). Now I want to display the details of the TOP 1-3 customers in…
-
Drill down to multiple screens
Hi all, I hope this message finds you well. I'm reaching out for assistance with a specific report feature I'm trying to implement. I’m aiming to create a dynamic drill-down functionality within my report. Essentially, I want to be able to select a cell from a specific column in my report, which should then navigate to a…
-
Select All, in Pop up Selectors
Hi, Our users ask if there is a way to select all elements in a Selector pop up. There is the Clear selection on the bottom left corner, but is there somehow a way to select all elements in one click?
-
Security Profil - Reset all selection in procedure
Hello, I have for all users a security profil Select User = @User and user meta data on organisations. User Role is a parent of user. On some screens in design mode I have selections (on organisation, periods…), "disabled initial layout" is checked. I try to make a open trigger procedure , according access to the screen or…
-
Is it possible to restrict the access to special menu items?
Is it possible to restrict the access to special menu items, e.g. for a special group of users?
-
Upgrade Board 14.2.2
Hello all, Board writes that you should update to version 14.2.2.. Where can I find this version? On the Update page I find only the Version 14.2.1. Kind regards Stefan Batalia BI Administrator
-
The last version of the Office Add-In wont work
Hello, I just updatet to the last version 14.2.1.1.300300. When I try to connect, I get an error. cod_ref:: 1741807****** here are 6 random numbers After a downgrade to 14.2.1.1.282551 everything works fine. @Board: Please check and fix it. Kind regards, Marco Oerder
-
Rule Configuration on Entity in a Relationship
We have a rule that consolidates P&L accounts into calculated reporting accounts (GP, SG&A, etc.) and it is configured by the lowest level of an entity relationship (child). However, we use its parent in the axes and I'm curious to know if that will break anything in the display of the rule since the manual states that the…
-
YoY Growth
I am creating an application where I have to show YoY growth of every expense present in dataview. What's the best approach I can perform to add YoY growth percent below every expense without adding that member in the entity already used. Attaching the screenshot for the reference.
-
Layout exceeds rows limit
All, I have a layout with 12 blocks. It is an algorithm block that is causing an error. a. Text Block b. MID(a,2, 30) It is the block with the MID formula causing an issue. When the algorithm block is marked as numeric, the layout works fine and shows 0 in the column. But when it is changed to Text, I get the below error.…
-
Data Entry with a Select in Layout
Hello, Is there a workaround on the issue of enabling Data Entry when Select is used in layout (see picture)? I wanted to select only specific members of an Entity for users to enter data. I don't want to show all the members of the Entity as they are many and we are only expecting input against a specific number of Entity…
-
How to manage leap years in a dataview?
Imagine a dataview displaying a sales-related cube: the first column represents the current sales values, while the second corresponds to the previous year's (PY) sales values. I want to compare sales from January and February 2025 with those from the same months in 2024. However, the PY data is incorrect because Board…
-
YoY Growth Calculation
I want to calculate the YoY growth of every expense mentioned in the cube and want to show it in the dataview. attached the screenshot of the view I want to show in the screen.
-
How to increase time out time for the Excel Add-In
We have a large report, when running this in Board itself, it takes quite a while, but all opens up fine. When we try to refresh the same report using the Excel Add-In, it gives us various errors. We believe this is due to the time out time not being long enough. Would anyone know how to increase this time?
-
Heading/Legend clean up
Hi All! I am trying to clean up a cartesian chart where switch row/column is enabled in the data pane. Here's my Layout Editor below. I just want to get rid of the "operating income" text after the heading; this shows up in both legend and bar names. "operating income" is coming from the layout select: Here I use a…
-
Weekwise and Monthwise data entry in same cube
Can we enable a cube to allow monthwise and weekwise data entry ?
-
Datareader - SQL Connection
Hi All! We are currently implementing a new Data Warehouse with a direct connection to Board. Now, my problem is that the DataReader does not always show the available tables and views from the Data Warehouse. Within the Cloud Portal, I have set up the access correctly, and the test was successful. Sometimes, it works—I…
-
Default relationships (missing parent)
"Default button" to fix the missing relationships: is it a one-time solution for members to "missing parent" at the moment or can you use that function as a default automatically for new members that have a missing parent?
-
Selection on screen
Hi everyone, I need to display data for different months on my screen. Specifically, I want the current month to be selected in the screen selection, and I also need a graph that shows data for the 12 months prior to the current month. Can anyone guide me on how to achieve this?
-
Database security profile lock out
I had a data model that I didn't have any database security profiles on and could work on. I needed to add some security to it so I first created an admin profile for myself with the following parameters: Access Mode: Database Administrator Security System: Builder Security Filters: None I named it ADMIN as that's what…
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
ALM Transport from Development to Production
I've used the Data Model and Capsule snapshots and transport packages in the past without any issues. However, I'm having an issue with one where our development environment (14.1.0.0.161052) is now on a different version than our production environment (14.1.0.1.240135). I created the data model package and moved it from…
-
Show All Text Cube Values for Each Entity Member
Hi all, Is it possible to show all text cube values for each specific entity member? I am trying to show all values from a text cube that are mapped against the accounts (See sample table below). When I try to use the text cube in the Layout, it's only showing one line of text when there should have been multiple lines. I…
-
Flex Grid filtering then exporting
I have a flex grid that I'm trying to export a subset of the data. So I go to one of the columns and filter it. When I then go to export it to Excel, it exports, but there is no data in the Excel file. No matter what column I filter on or what I choose, it exports an Excel file with the correct column headers, but no data.…
-
Security Settings do not apply with "Refer to"
Hi everybody, in our Board 14.1 (0.1.244711) we have a cost center dimension, that is used for the database security. The cost center dimension aggregates to three different hierarchies (legal entity, business unit and technology). Furthermore, we have a dimension for P&L lines. We have created a dataview which has the P&L…
-
Formatting data in hierarchy
Hi, I need help to do a formatting. I have an hierarchy like this - Red box is Level 1 (Parent),Green box is Level 2 (Parent) and Blue box is Level 3 (child). Level 3(lowest child) ← Level 2 ← Level 1 Is there a way by which I can format this hierarchy on screen…such that level 1 appears in font size bigger that level 2…
-
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
-
Move file to archive directory
Dear, Is it possible to move a file after it has been read by a datareader to an archive folder. Is there a command that can be used in procedure to execute a copy command etc. Thank you
-
Are exclusions of certain characters possible while entering text data ?
Is it possible to exclude certain characters, spaces, enter etc. when entering text data in board? E.G. Data Entry for a space " " is forbidden.
-
Board data entry
Good evening, I am trying to create a budget report that allows users to edit values through data entry. The following table presents the data in the following order: Months in rows (entity) Sales from the previous year (cube) Budget for the current year (cube with data entry enabled) Sales for the current year (cube) As…
