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.
-
Question about dynamic selection with two parents of the same entity
Hi Community, I’d like to share a slightly complex use case that might open a discussion on potential improvements or clarifications around how dynamic selections work in Board. 🎯 Context: I have an entity called Month, which has two parents: Month of the Year → contains values like January, February, etc. Year Period →…
-
Interaction Block Format
Hi, I have a question regarding the Block format. I'm trying to add a symbol after the number, but it doesn't work properly when I use the algorithm in the layout editor For example the image below, for some reason it can't show the euro sign for every month but only for the null cell i hope you can help me thanks 😀
-
Efficient way to copy value in the Procedure
Hi all, I'm trying to improve my current Procedure i have a cube with 3 dim ( Drivers, Month, Type A or B) My goal is to copy the value from Driver 2 Type A → Driver 3 Type B as you can see in the image below My step is: 1) copy the original cube into a Temp cube 1 2) Clean the Temp cube 1 using the selection on Driver…
-
Interacting with a Dynawrite Object
Hi Everyone, does anybody know how to write on a dynawrite object on play mode?
-
How do i change the number format
Hi, I have a question regarding the format of the number in Board how do i change from the format of number from "," to "." → for example 25,000 to 25.000?
-
Dynamic Visibility of a cube / data block in a data view
Hi, is there any possibility to steer the visibility of a cube / data block in a data view? I want to achieve that I can steer on an admin scree, if a certain cube/data block is visible in a data view on another screen. I know that you can steer the dynamic visibility of the whole data view, but I need it for a certain…
-
Linear Programming Problems in Board
How can we solve Linear Programming Problems in Board - Nexel or Procedures or any other tool ? Example contribution maximisation with limited machine hours, what should be the product mix. In Excel we can solve this using solver addin.
-
How to Group Columns by Cube in Data View Layout
Hi everyone, I have question about data blocks Detail by Month As shown in the attached screenshots, the columns for Q Ovun (PO) and Q Ovun (GR) in the Data View are currently sorted by month, which results in an alternating pattern (e.g., Q Ovun (PO) Apr.25, Q Ovun (GR) Apr.25, Q Ovun (PO) May.25, Q Ovun (GR) May.25,…
-
Detail by On a block
Hello Team, I have a question regarding the Detail By option on Cubes in a dataview. Is the Detail By similar to a Group By. I see from the documentation the Detail By overrides the by column axes. Also, if we consider below documentation, why would i override country by Channel by using Detail By when i could only set By…
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
How to Change the Export Excel Column Header and Total column Color
Hi, Please guide me how to amend the color for column header and total column color. Thank you. Sin yee
-
Skipped rows of Cube value of 0
Hi guys, I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null. Anyone have some ideas or solutions about this one? Thanks previously
-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
Entity member sorting
In configure layout of data-view, I have taken cubes with required dimension and the entity on which I want to apply filtering and sorting. For sorting, I am using the algorithm -…
-
Hover-over cards not appearing on Bubble Chart object in B14
Hi, We've recently migrated a reporting capsule to B14 from B12 and it's come to our attention that hovering over bubbles in the Bubble Chart object, no longer brings up the card which details the values of the block. Has anyone else experienced this? Is there a setting I now need to toggle on, or is this a bug? Cheers!
-
Selecting Months for Single Month & Multiple Month graphics
I am trying to set up a screen that uses a single month selection for a waterfall chart and multiple months for a graph of monthly figures. I have managed to get a procedure that selects the last twelve months, however I could not use this selection alongside the waterfall chart. I have tried using a custom time entity but…
-
Column Entity Always Show the Total Members and Not Display the Actual Value in Dataview
I want to know the causes of why my Part Number column entity always show the total members and not display the actual value? Did I have some mistakes in mapping my cubes? FYI : Cube (Mixing Ratio)→ Have 3 entities mapped into it (Part Number, Plant FG, Supplier/Cost Center) And here captures of my settings in Layout…
-
Selectors - Active Selection
Hi, We have a Selector on a screen which shows the Active Counter and Active Percentage. The entity of this selector is previously prefiltered by a On Open Trigger procedure. This makes it display 20/50 elements even if the user has not Selected anything. From the user point of view, he/she should only see 20 elements. And…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
