-
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,…
-
Level 300 : Backup Failed
Hi Team, I tried taking a backup as I was facing an issue in module 305, Update Sales Planning. So, thought of trying the workaround mentioned, deleting members, but the backup of the DB failed. Screenshot attached.
-
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
-
Level 300, Module 305 - Functional Q 1
Hi, I am currently getting an incorrect response for the CY Forecast amount for Grey Pearl Stud. I have checked the steps and instructions numerous times but just cannot seem to work out where the issue is. Having looked at what the correct answer/amount is, it seems for whatever reason my procedure is doubling this…
-
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?
-
Level 200, Module 212 - Income Data Issue
After I click on the "Update P&L" label, the P&L comes through but only for the expense data. The income data does not populate. In the training documentation, this data is included. Where could I have gone wrong?
-
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…
-
2025 May Badge of Impact
May is here and with the start of a new month we're very excited to share with you a new video series called CommunityCast. In this series, we'll be providing a quick round-up of recent updates in one minute or less—ranging from new content, programs, technical and structural updates to Community, and so much more! Stay up…
-
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…
-
Level 300: Expanding Board in Your Organization Part 1: Environment is not setup
Hello, Im currently doing the level 300 training. The environment has not been created despite i clicked on setup. Now the course also make reference to Level 200 datareaders. But i do not have access to these envs anymore. Kindly advise
-
Level 200 - Training environment expired
Hi, Unfortunately the level 200 training I started expired and I was not able to complete it due to time constraints. I would like to restart it to complete the level 200 training but I just get the expired message. Is it possible to extend the instance?If not, I would like you to reset the training environment.As for my…
-
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…
-
Level 200, Module 205 - Impossible to create a 'Call procedure' step
Hello, I'm stuck in the Level 200, Module 205: ACT - Sales Data Load Capsule Procedure. I need to create a capsule procedure that contains a group 'Call DB Procedure' with the step 'Execution flow: Call procedure'. However when I try to do this I cannot select any procedure in the drop-down, it's simply greyed out. I've…
-
205 UK Data Not appearing in the Sales Planning screen + Initialize Budget does not work
Hello I am currently blocked on 2 problems currently: First of all, In the Sales Planning Screen, no data appears in the different visuals when I select UK, see example below What is strange is that is that in the Sales Actual screen, I can see the UK data, Both tables use the same data cube in entry. Moreover, I do get…
-
LEVEL300, Module305: Regarding Functional Test Question 1
Hi all! I am struggling with Functional test question 1 in level 300 module 305. Already checked all the steps 3-4 times, still cannot find what's the issue: when I am completing the steps for Functional test, I am getting correct result for 2 planning products, and the incorrect one for one planning product, as shown on…
-
204 - Procedure - Selection Step bug
Hello, I'm following the B14 204 course and I have an issue where when I want to select "Timestamp: ACTS - Actual Sales Upload" in my procedure, nothing is available. As you can see here, I cannot select anything. I've been told that it is a UI problem, but is there a way to circumvent it? I have reloaded the VM but…
-
Level 200, 203 Force kick from go to screen
I'm currently having a strange bug where when I click on data management on the home screen to go to Sales Data Upload, 4 times out of 5, I get force kicked of Board and I have to reconnect myself. I don't know the cause and it doesn't do it every time, which makes it even more unusual. It seems like a critical bug if it…
-
Monthly Customer News Update - May 2025
We’ve been busy behind the scenes, and we’re thrilled to share some big, exciting updates with you today: Board 14.3 is coming Get a sneak peek What's happening in the US market? Watch our economic outlook Need a best practice? Check out the customer stories by Kraft Heinz, Iren Energia, and Dr. Beckmann How mature is your…
-
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…
-
Run an SqL data reader on the current selection
Hello, I'm running a data reader from a procedure with the YEAR (called Année) selection. I would like to scope the data based on the current year (selected when the data reader is run). Below the SqL command. I guess I should write something in the "Where" section. I tried with @Année which did not work. Thank you very…
-
Cleaning data in Data Reader with exclusion rules
Hi everyone, I'm currently working with the Data Reader in the Board Platform and I need some help with cleansing rules. I would like to exclude certain rows from being loaded into the entity based on specific conditions. For example, I want to prevent any record where a value starts with "5HR014" from being loaded into…
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Board call API using OAuth 2.0
Hi Community, I want to create a Board "Data Source" connector to Google Drive API using OAuth 2.0 authentication. I have created an id application on Google Dev/Cloud. But I am not sure about the Board Callback URL section. For now, I use url callback: https://my-domain-name/en/Callback.html. When I create a Data Source…