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.
-
Drill Through popup : How many rows it can safely handle ?
Hello, Is-there any BOARD tech lead here ? Our users are using the drill through feature towards an SQL server database to see invoice accounting lines on SQL DB. However on some accounts, we have approx. 100 000 lines of invoices to display on the BOARD drill thorugh popup Question : Is the drill-through feature natively…
-
FileRead ERROR:File Missing what is the causes of Datareader file missing?
Hi all, I want to know the causes why when I tried to run Datareader manually, FileRead ERROR:File Missing always be shown? I have checked the path is ok. Any ideas about this issue? Thanks.
-
Search function / Excel PlugIn
I want to use the search funktion in the Excel plugin für an entity's ID. Unfortunately, it's 20 characters long. Can I configure the search function so that I get the correct result if I only enter the last digits and not the full 20 digits? Look at the screen shots. 1.) 2.) I get no result :( I'm looking forward to your…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
Calculate Mix including Subtotals
Hi there, how can I calculate percentage mix including subtotals? At the moment it is calculated by group. The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years. However I need it by year. Thanks maik
-
Unsynchronized Procedure names
Hi, I needed to adjust a procedure that is assigned to a field in a Dataview. However I could find it in the data model. Because it has been renamed at some point How can I synchronize the names to ensure someone can find it? Thanks, Maik
-
Why does the "Previous Year" time function still return current year data?
I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or…
-
Sorting in Data view with Detail by
Hi can someone shade some light into sorting logic with "Detail by" activated? a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview When I move it to spot - b - I can see Occ TY by Year - However now the order of the other columns is screwed. Any idea how to fix this? Thanks Maik
-
Representation of a diagram
Hello everyone I have the following initial situation (see also the attachment): I want to create a chart in which I have to expand a cube after an entity, but not the other cubes. I solve this via detail by on the cube in the layout. However, the problem is that I want the values of this expanded cube to be displayed…
-
Performance Problems in Board Frontend - Windows Log ID 7011
Hello, For several weeks we have the problem, that the Board frontend stops working for some time (often 1 or 2 minutes), so it does not answer any questions from the client any more. When this happens, all users are blocked. They are not locked out, only the requests to the Board reports, running at the moment, seem to be…
-
Upcoming Board Cloud IP Address Change
Hi , Anybody can guide on what to do with the Upcoming Board Cloud IP Address ChangeRgds Khaleelah
-
Delete entity member through entity editor object
Hello, Is it possible to delete an entity member when using the entity editor. The documentation says CRUD operations are allowed once ATO is enabled, however i cannot see the option to delete. Thanks
-
Data entry logs in LMA Application
Hello, In the LMA Application, there is a screen with Data Entry logs (13.xxx) : Cubes used in this screen are loaded through the DR DE - Values using this path, but there is no such file in it. Is there an other way to load this log ? Thanks
-
Maximum Data Blocks within a Data View
This takes me back to excel days. I'm currently at FD with data blocks and I'm blocked from adding any more in. Is there an upper limit? Has anyone had this same issue or never gotten to this many blocks? Build is in B14.2. I'm trying to add algorithms in not additional data blocks. Doing this with right-click add rather…
-
Normalizing time hierarchy
I have enabled the week dimension in time range settings. This is the setting windows. The hierarchy looks something like this - I have updated the hierarchy and normalized but the aggregation function is not working as expected. When we are trying to roll up from week to fiscal year the total is coming wrong.(I have…
-
Pass the Screen Name to Capsule Procedure
Hi all, Is it possible to pass the Screen name to capsule procedure? The screen name will dictate which Group of steps will be used in the processing. I wanted to combine the multiple procedures we created into one which will have an if clause that will check the screen name and go to an appropriate group for processing.…
-
Issues with 'Detail by' sorting feature
This issue has popped up in the layout editor after I added an entity in the configure drill down. The data is tying out correctly for all my data blocks, the only issue now is when I try to drill down on a specific P&L line. The drill down shows every member in the entity rather than the specific line I am trying to drill…
-
Change day formatt in time range ?
Hi ! Can anybody tell me how can i change the day format from "mm/dd/yyyy" to "dd/mm/yyyy"?
-
Question about Label
Hi all, I'm trying to figure out how to cancel the label's animation. I'm using the label to partially cover an image by adjusting its opacity, but whenever my cursor hovers over the label, it lights up based on the label's color. before and after do we have other Object to use it or some setting for the label? thanks 😀