-
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. https://player.vimeo.com/1105912052 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.…
-
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.
-
Add Filter to a screen
Hi all, I have Screen1 and Screen2, in which i want to apply the same filter for Entity. Through a procedure I managed to apply the same filter (that we can call "Deal") to both Screen1 and Screen2, by selecting it from the Screen1. Keeping in mind that Screen2 is already filtered for "month", when i apply the filter…
-
dataflow problem
Hi All, i have a problem with a calculation between 2 cubes First of all, i want update the cube B (5 dimension) using the value of Cube A (2 dimension \the other 3 dimension i used the filter in the procedure) without delete the other part of the cube B. the Algorithm use the cube A and B explained before. The reason of…
-
When procedures triggered from screens fail you 😯
We are looking at all cases where a procedure executed from a screen can fail and stop. We have found what I relate below. ⚠️ Could you, please, point to additional cases? This way they are registered for future consultation by other members of the Community. ⚠️ When a procedure is launched from a screen, it can be with a…
-
Optimal Management of Temporary Cubes to improve RAM Efficiency in Procedures
In my current Board implementations, I rely on temporary cubes extensively due to their impact on readability and performance management. However, I've noticed they can consume considerable RAM, especially during data-intensive procedures. Given this, I’m wondering: does it make sense to clear the content of temporary…