-
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
-
Can you Procedurally Export to Excel?
We have a budget cube that is loaded to via the smart import object. After a bit of transformation on our end, we want our users to have the ability to export this data in xlsx format (same format they initially loaded to in the smart import object) for their own purposes. We would like for there to be an interactive…
-
How to use Nexel to select custom time periods
*NEW - includes video demonstration. Build Along with Board Follow along as we bring this step-by-step guide to life. Quick reference: 4:32 - Custom time period selector 7:23 - Create members 8:38 - Create the cube 10:09 - Create Nexel layout > complete Nexel process begins here 1. Abstract While conducting reporting, the…
-
Level 200, Module 207: After "Apply 5% Increase" the "CY Budget" Data disappears => no data
When I click on "Ally 5% Increase" the CY Budget data disappears and no data is left. Before: After: Label Config: capsule procedure: data model procedure: Do you need further information/screens? Many thanks in advance!
-
Level 200, Module 206: Label with timestamp shows "0" after click/trigger on "Initialize Budget"
When I click on "Initialize Budget" its loading the data, but the timestamp doesn't appear respective is "0". capsule procedure: data model procedure: Do you need further information/screens?