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.
-
Flex Grid Algorithm / and Grand total
Hi, I have another flex grid question. I have created an algorithm in a flex grid (PIVOT mode) when adding an entity to columns it doesn't do the calculation anymore. Any idea why that is? second question: How can I show a grand total in the PIVOT mode? Thanks, Maik
-
Flex Grid Export
Hi there any idea when the speed of exporting a flex grid will be enhanced. It is very slow. Any thoughts how to get the exporting job done maybe in a different way? Thanks maik
-
Missing pages on the manual
Hi, so there are same pages missing in the manual, mayby links that hasn't been updated. From here, do you have any information why i get [0x-7feceb00] - AccessDeniedToDatabaseFromProcedure when trying to run scheduled task?
-
Time relationship for custom time range entity
Hi there, I need a new Half Year entity, parent of Quarter (Q1+Q2 = H1; Q3+Q4 = H2) and child of Year. Entity members have been populated for all years in my system. However, when I try to fix the relationship as Day > Month > Quarter > Half Year > Year, this new entity doesn't get captured in the correct way. If I drag…
-
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…
-
Problem with Yearly moving total function
Hi i have some issue regards the function Yearly moving total Below you can see the data in Q1/25 ( there is not other data after Q1/25) but after i use the function the value inside Q1/25 will be null even if i use the cycle function→ (the cycle is set to 9000) Do we know the reason behind this? thanks
-
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. 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?