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.
-
Month On Month Variance
Hi BOARD Team, I created a simple procedure to calculate month-on-month variance. But I cannot see any output. If I use a + b, I can see the result, which calculated correctly. But if I use a - b, there is no result returned. Could you please help me to troubleshoot? Thanks
-
trigger procedure - user connection / home page
Hello, Is it possible to trigger a procedure when a user logs in or when he arrives on the home page of a capsule? If so, could you please let me know how can it be done? Thank you
-
Working with Dates
Greetings, I have a Date field in a Board Report, and I'm trying to Split the Date into Month and Year using Board inbuild feature not by SQL via a Data reader. E.g, I want to split this as (first row): Month = 9, Day = 30, Year = 2024 where each of these is a separate column. Any hint or documentation on how to accomplish…
-
Apply Selection to Layout Block - Chart / Dataview
Hi i would like to change the apply a different selection to a block however I receive an error in chart and dateview: When i change it manually it works. Interestingly despite of the error trackball is still showing but with the wrong numbers. Any idea what the issue is?
-
About Sparsity
Hi Team, I am reading the Best Practice Screen, which suggests that version / scenario can be set as Dense to improve speed. https://community.board.com/discussion/16440/sparsity Just for the learning purpose (not means I will change it), we should review the folloing Sparsity? Thanks
-
Is it possible to have no totals for certain algorithm blocks in the total line of a dataview.
I have a dataview with total lines but besides "normal" data I have a column with a algorithm block showing percentage values in a tooltip (as information for the user, so that he know which maximum percantage value is allowed to be entered) - for this percentage values in the tooltip I dont want to see summed up totals,…
-
Hint in dataview
Is possible insert in a dataview different hint for each column header?
-
Flex grid calculation
Hello, I am using the flex grid as below, the Var % is calculated as (78081-75790)/78081 * 100. This is calculated well on each line. However , when i am grouping and aggregating value, the variance is being summed up which is incorrect. It should have taken (10,498,902 - 11,700,011)/ 10,498,902 * 100 = 10 %, on the screen…
-
Can I create 2 dynamic selection entity based on cube in screen or dataflow?
Hi all, I want to know that, can we create 2 dynamic selection entity based on cube in screen or dataflow? For example : Entity A, Cube A, Cube B I want to make : Select Entity A based on Cube A Select Entity A based on Cube B Is it possible if the scenario should be like that? Thank you.
-
Problem Loading images with Data entry
Hi everybody, I’m currently struggling to upload some images into a BLOB cube. I already have a cube containing different items, and I’d like to associate each item with its corresponding image. To do this, I created a BLOB cube with the same dimensions as the original one. Then, in a Data View, I tried to enable the Data…
-
Flex Grid Totals on collapsed groups
Hi, any how to show subtotals on collapsed groups in a flex grid and in general to show totals when expanded?
-
Year-End Value While Retaining Month Drilldown
Good afternoon, I am trying to create a graph that displays the year-end value. At the same time, I want to maintain the ability to drill down by month and see all the preceding monthly values. Does anyone know a method to achieve this in the graph? Thank you.
-
Color Alert
Hi, I would like to apply a color alert. I have created an true or false formula which is used in the color alert. when I have true or false formula unhidden the alert works but not when it is hidden. Any idea what I am doing wrong?
-
Problems with Sparsity Optimization
Are there known issues with the sparsity optimization in BOARD. We carried out a sparsity optimization and afterwards the entries of the cubes (before the optimization and after) no longer matched.
-
Flex Grid - Opening fully collapsed
Note - Ignore this, found the solution! Is there a way to configure the flex grid so when you load the screen it loads fully collapsed to enhance speed?
-
Clarification on “Max Item Number” when creating an Entity
Hello, I would like to ask for clarification regarding the Max Item Number option when creating a new entity. When the Max Item Number is set to Auto, what exactly does it mean? Does the entity accept an unlimited number of members? Or is there still a hidden system limit that we need to be aware of? I want to better…
-
Is it possible to use an RTF cube as the body for a Broadcast email?
Hi! I'm working on a Broadcasting module for a solution and I'd like to let certain users create the body of their emails using data entry. I've always done this with text cubes in the past, but I was wondering if it was possible to do the same with an RTF cube - since the Body editor in the Broadcast area appears to…
-
How can I transform this formula into dataflow procedure?
Hi all, I have this excel formula like this one : INDEX Price from KSB1; MATCH By Cost Center and By PN Material Consumed MAXIFS(By Period; By Cost Center; By PN Material Consumed; Period Between Actual From and Actual To) So how can I achieve this value by using dataflow procedure? and how it should be of my cube…
-
Unable to access the screen "Screen already in editing"
When I am trying to access the 'Sales Data Upload' scree, It is showing a pop up "Screen already in editing". There is no screen opened, I logout and login. Although, I am unable to access that screen. Please anyone can help me to resolve the issue?
-
Button or Switch for Difference and % Variance Calc
Hi all, I would like a button or selector that gives the user the ability to switch between difference and variance. Any idea how to approach it? Thanks Maik
