-
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…
-
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…
-
Saving @Selection_Ex() result
Hi all, We are working on new functionalities for cost allocations, where we will need to store the explicit selection made by the user. This selection can be done on 1, 2 or 3 different trees, containing up to 30 entities each. I don't want to store the resulting selection at the lowest level of the allocation driver…
-
trigger an ADF pipeline via rest call API in Board
We want to set up a procedure to trigger a pipeline in Azure Data Factory trough Board to refresh our sql tables in the datawarehouse However when checking the log we get the following error: {"ControlFlow":false, "StackTrace":"System.Threading.Tasks.TaskCanceledException: A task was canceled.\r\n at…
-
Pacer vs. Selector
Hi there, I have a screen in which I have a pacer which is filtering months. I created a procedure that should apply the filtered month to the next screen. However it doesn't do it. Therefore am I correct that you need to have a selector always when you want to screen selections in a procedure? Thanks, Maik