-
Article How to loop procedures
Hi, Just reading through the article : How to loop procedures One part says Loading the extracted sequence into the Enumerator Cube so it looks something like this: How do I load data into a Temporary cube? Via the Data Reader I cannot see them. Thank you Maik
-
Monthly Customer News Update - September
Stay up to date and rewire your brains with the latest contentand trainings to lay the foundation for a successful H2 and beyond. We wouldalso like to highlight the G2 review campaign which includes a donation to a charitable cause: Product: Board 14.4 is here with an updated data reader, plus: SOC 1 Type II Report How to…
-
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
-
Apply Selection to Layout Block - Chart / Dataview
Hi i would like to change the apply a different selection to a block however I receive an error in chart and dateview: When i change it manually it works. Interestingly despite of the error trackball is still showing but with the wrong numbers. Any idea what the issue is?
-
Level 300 Part 2 - 310 Functional Test
In the first question of the function test, I am required to push the button to update P&L, but there isn't an "Update P&L" button on that screen to be selected. I have also gone through the instructions again, and there are to steps where we need to set up the button. As a result of this, I'm unable to get past the first…
-
Level 200, Module 206 5% increase to budget
While this seems like a great procedure in the module, for our org, curious how easy it would be for the % uplift to be dynamic for cases like this. My question is, instead of a procedure that will increase sales budget by 5%, is it possible to create a procedure where it will take a % uplift input by a user, and increase…
-
Board Scheduler
Hello, It's my first time trying to schedule a nightly procedure run. I'm on board 12.6 and I'm having a hard time finding the scheduler in system admin portal. I will appreciate any resources and/or screenshots on how to locate the scheduler and schedule a nightly procedure run. Thanks, Walter
-
Trigger a Board Data Model Procedure from Excel Add-in
Hi All, Has anyone tried to trigger a Data Model procedure from Board Excel add-in using an API or any other approach? Regards, Vikash
-
Best practices for using "Back Compatible" option in Dataflows?
Hi everyone, As part of a migration project from Board 10 to Board 14, I’m reviewing the use of the "Back Compatible" option in Dataflows. I know this option should not be used with HBMP dataflows, but I’d like to go further and understand: Are there any additional recommendations or best practices related to this option?…
-
Level 200 : 210 No Data on Expense Planning Data Views
Hello, I am struggling to populate data into both the Annual and Monthly Data views. I have gone through all the steps again. I have also re-run all data readers and the BUD - Initialize Budget procedure, but my view is still empty, and hence failing functional testing. My currency selector also shows 2/2 instead of 1/1 as…
-
Limitations when pushing data from MDB to RDB via Dataflow
All, Are we aware of any limitations when pushing data from an MDB cube to an RDBMS using a dataflow? Scenario Overview: We have an MDB cube composed of four entities - 3 General Entities + 1 Time Entity Entities Max Item Item Count Entity 1 100000 30141 Entity 2 1000 41 Entity 3 100 8 Month Infinity 204 The goal is to…
-
Unsynchronized Procedure names
Hi, I needed to adjust a procedure that is assigned to a field in a Dataview. However I could find it in the data model. Because it has been renamed at some point How can I synchronize the names to ensure someone can find it? Thanks, Maik
-
Validation of End Date Earlier Than Start Date
I have two data cubes with the month dimension, where a 1 is stored in the cell corresponding to the date selected by the user. Cube 1: Start Date Cube 2: End Date I need to implement a validation so that if the user selects an end date that is earlier than the start date, the system displays a warning message prompting…
-
Pass the Screen Name to Capsule Procedure
Hi all, Is it possible to pass the Screen name to capsule procedure? The screen name will dictate which Group of steps will be used in the processing. I wanted to combine the multiple procedures we created into one which will have an if clause that will check the screen name and go to an appropriate group for processing.…
-
End Date on a Day (as Start Date)
In the rows I have the day entity. In column 1 the possibility to enter a number of new hires and in column 2 the end date for the new hires. The date on which I enter the new hires should represent the start date. In a procedure, the number of new hires should now be written to the days from the start date to the end…
-
Level 200 : module 211 - SET - Flag Budget and Actual Years
Hi, I don't understand the procedure : SET - Flag Budget and Actual Years In particular, the calculation of the data flow when the time function is selected on "Last value" in the cube "SET - DE - Planning Year". What does that mean ? What is the result if for exemple the value in the cube is SET - DE - Planning Year is…
-
Procedure: Extend Calculation on new tuple for all members
We have a source cube (Input Cube) as shown below with dimensions highlighted: We have a target cube as shown below with its dimensions highlighted: How does "Extend calculation on new tuples for all members" affect when we are copying data from source to target cube? What happens if we select all/ any of the members and…
-
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 →…
-
Procedure Select step critical bug
Hello, I am following the 212 module and I am working on the BUD - Consolidate Budget into P&L procedure. after following every step, I am stuck at the Select Account step in the sales group. The UI element that is supposed to allow me to select an Entity isn't working. No bypass that I know of is currently working (not…
-
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.
-
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…
-
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…
-
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…