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 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
-
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…
-
Cannot Access File
Hello Everybody, I need your help for this specific error occurring while I am trying to modify a certain procedure. You can find the screenshot attached. This error appears while I'm trying to save the changes to the procedure, and it happens both on S1 and C1, while if I make a copy of the procedure and modify it, it…
-
How best practice of dataflow ?
Hi all, I want to ask about related like this documentation below captures : So, Let's say I have same case like above capture, and then let's say Product = Part Number and Salesperson = Material Consumed. And then I didn't use Month dimension to calculate it in dataflow. For Part Number and Material Consumed is standalone…
-
Export full presentation to Excel instead of slide by slide
Hi Community, Does Board allow us to export a full presentation (presentation menu) to Excel instead of doing this slide by slide? Is there any options or button to apply for this? I would really appreciate that it is possible, and know how. Thanks a lot in advance for your attention. Regards.
-
Dataflow - Storing the values based on the Reporting Unit Default Currency
Hi all, I would like to get the value from the source cube based on the target's RU Default Currency (Parent of the RU entity). The Source Cube has values in all currencies so would like to get only the value corresponding to the RU's default currency. If the Target's RU Default Currency is GBP, it should get the value…
-
Board: Using Entity Creator
Hello Board Community, I’m working on a Board assignment where I need to allow users to assign Brands to Product Categories, and eventually link them down to Products. Steps done: Created an Entity: Brand Added Brands like A, B, and C. Created a screen using the Entity Editor to allow users to insert and edit Brand names.…
