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.
-
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…
