-
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?
-
How to use period by period recursion
1. Abstract This article will highlight the advantages of seamlessly incorporating a native functionality, like the “Period by Period recursion” function, within a business context. It illustrates how this integration simplifies tasks, boosts scalability, and optimizes maintenance, providing practical insights for its…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.