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
-
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,…
-
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
-
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?
-
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
-
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
-
Is it possible to configure UK number format in BOARD
I have requirement by which i need to implement thousand seperators just like in UK number system. For example - if i have a value as 1019443. In UK format it should appear as 1,019,443.But in BOARD currently it appears as 10,19,443. Can i set the number format in BOARD also to 1,019,443
-
Drill Through - ERROR [HY000] [Oracle][ODBC][Ora]ORA-00920: invalid relational operator?
PLEASE HELP I've spent weeks trying to solve this drill through issue. I'm trying to Drill through a dataview using the following entities: Month Reporting Cost centre Account Originally i could get the drill through to produce results for reporting cost centre and Account correctly but not filtered correctly on the right…
