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.
-
Drill Down
Hi all, is there a limit how far you can drill down? Thanks< maik
-
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
-
What is the purpose of "Position Changes" in the Data Model Transporter?
We recently executed a backup and restore of our core data model from production to non-production. Everything was aligned momentarily; However, as soon as we developed a couple new objects (cubes, rules, entity formats), the data model comparison tool exploded to show several hundred changes between environments. Of the…
-
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…