-
Hochrechnung der Umsätze
Darf ich hier die Frage stellen, wie ich anhand eines Screenergebnisses einer Datenview automatisiert hochrechnen lassen kann? Ist sowas möglich oder nur wenn ich es ins Excel bringe?
-
ToolTip on Row heading
It would be good if there was a way to get a tooltip to show on the Row heading column. There are times where the tooltip to be displayed relates to the entire row and not just a particular block, in these instances it would be very useful to have the tooltip show on the row heading/entity. At the moment the only options I…
-
Level 200: Module 206 Copy PY Actuals to CY Budget
Hi there, I am having issues with my procedures to load CY Budget from the PY Actuals. The capsule procedure begins successfully, and can see it actions the data model procedure as the timestamp updates. However, the data flow step in the Data Model procedure does not appear to run successfully, and I do not get the…
-
trigger broadcast functionality via procedure launcer
Our customer has the broadcast license and is currently sending content critical time-controlled status reports. We would liked to trigger this automatically at the end of the data preparation with the Procedure Launcher and not (necessarily) delayed (since the data preparation has to be finished) by the broadcast…
-
How to structure cubes with slow moving hierarchy
1. Abstract A common challenge in a Board Application is to fulfill the request of tracking changes in hierarchies, which by definition are the current snapshot of a relationship. This article describes how to keep track of the historical situation using a cube and dedicated entities. 2. Context Since a hierarchy in Board…
-
Missing child in Relationships
Hi, I'm trying to create a dashboard on ESG Net Zero Emission. I've picked only a particular worksheet (1a_RM_&_pack_calc_1.csv) and created entities and built relationships for them, but after running the Data Reader, I'm getting an error on Missing Child in relationships. Thanks & Regards, Kranthikumar Goli.
-
How to read dataframes from R back in Board
Hi! I am struggling to use the R calculation step. What I am trying to achieve is to read back the "output_dataframe", defined in the R script, into a Cube. It is annoying since Board keeps on signaling the R DataFrame is incorrect (marked as red) even if not log statement is displayed, so I am not able to save it and…
-
Drill Actions
1. Abstract Board offers multiple drill options, it’s important to consider the requirements when planning or setting up drill options and to design the solution accordingly. 2. Context Board offers multiple options when drilling into data, which is the right one to use depends on the specific requirements – whether the…
-
Custom Entity Relationships in Time Range
Are Custom Entities only working as a parent to the lowest level? I'm struggling with the "Current Fiscal Year" (red mark). In selection phases (i.e. a screen selection), the selection of the entity member "Current" on the "Current Fiscal Year" won't apply on the child "Fiscal Year" (member "22/23" in this case). However,…
-
How to manage cloud tasks from on premise server - Orchestrator
Hello community i'm going to move to cloud and I know it's now possible execute a board procedure through an API call. Since I have various tasks to copy files to/from the cloud, to be synchronyzed with Board procedures, I would evaluate possible solutions to manage processes that combines batches to transfer files (with…
-
Level 200 training - Is it possible to please resurrect my training environment?
-
Lack of Agility
Agility implies the ability to change course when it makes sense to do so by observing changes in our environment, responding to what we know, changing circumstances, examining, adjusting frameworks, and restructuring approaches to do so quickly and inexpensively. Agility is a core driver and target of outstanding…
-
Board Academy Level 200 training environment setup error
I am getting the following error when trying to setup the Board Training Environment for the Board Academy Level 200: Selected user account does not exist in tenant 'BOARD' and cannot access the application '93cb9be1-06ac-46e9-8cb6-ef5235d40859' in that tenant. The account needs to be added as an external user in the…
-
Extract user's roles/rights from Database
Hi, It would be nice to have a fast accesable option to extract the user's roles and rights in a unified way from tne database. Not merely the Database security profiles or Folder profiles but also the values (from blocking cubes ) set for each user on entities like Product or Customer. Currently our customer extracts the…
-
Integrated technical documentation functions
1. What is your idea? The Idea is, to have the possibility to directly document the application within Board. For example: Entity Comment possibility for each Entity technical name Cubes Naming Convention field / technical name possibility to comment (maybe overall and in addition on Cube Version level) Value explanation…
-
extract all cubes > create log
Hi, when you execute an "extract all cubes" procedure action, no log is created. it would be really useful to have a detailed log about all the cubes extracted, in order to be able to check if everything worked as expected. consider that the "reload all cubes" already creates a detailed log on the reloaded cubes, so…
-
Selection Options in Procedures
1. Abstract Board technology allows different types of select, static, or dynamic queries. In particular, in procedures, it’s possible to choose between three methods that can seem very similar: Selection (fixed) Select Entity based on Cube Dynamic selection (from the “Select” step) Although they can give the same result…
-
Dataflow common mistakes and best practices
1. Abstract The dataflow is the main action to perform calculations between cubes, it is used in all the processes of the application, therefore it is very important to know how to set up a dataflow in the best possible way, to obtain the correct results with the best performances. 2. Context In this article, we will first…
-
Dataflow mode question (206)
hi - I am working through the L200 course. In 206 / Knowledge Check, there is the question: "What is the purpose of the clear cube step of the BUD - Initialise Budget Procedure?". The course's own correct answer is "The mapping mode on the Cube is set to ADD, which will cause the data to increase each time the procedure is…
-
How to design screens & dashboarding
1. Abstract Screen and dashboard design can at times make or break an application – if screens are poorly designed or unintuitive user engagement can be compromised from the off. There are many factors to consider when determining what constitutes a good design - from layout and ease of navigation to the amount of content…
-
Level 200, Module 205: Sales Planning Procedure
Level 200, Module 205: Sales Planning Procedure ACT - Sales Data Load Data Model Procedure Step: 4 Select "CALCULATION DOMAIN" and in the Extend calculation on new tuple for all members of section, select: "Country" and "Timestamp". Why are we extending the calculation? I am aware that it will open the dense cube dimension…
-
Board 12.6.0.1 : The JOIN function is not supported anymore
Hello, In Patch 12.6.0.1, as per the release notes : Dataflow : The JOIN function is not supported anymore and should not be used in the Dataflow configurations ⇒ Could you please explain if there is a change in the code related to JOIN() function : All dataflow with join() will now fail ? or it is for information purposes…
-
Community Roundup: August 17, 2023
The Community team is back and excited to share with you the new features we've launched and the accomplishments we've enjoyed in the last six weeks! From new tools, to streamlining navigation, to Community member outreach; we've had a busy six weeks of growth and evolution. The new features and Community accomplishments…
-
IBCS Standards
I would like to suggest to enrich the dataview and graph settings to help building a BOARD application using reporting standards as suggested by the IBCS® standards (International Business Communication Standards). These standards aim at providing a consistent reporting set for the user, so that he can very quickly know…
-
Measure Totals in Data View: Force to be a sum
Hello Community, I am running an issue with the total value in a data view and wondering if there is an easy way to solve it. I have an example below I want to calculate the $ impact on price difference (column K). For individual row the calculation is correct, not saying the total is wrong but I just want to force the…
-
Best Practices in Writing Procedures
1. Abstract Most probably every Board application will have procedures to cover interactivity by the user (e.g., navigation), perform calculations (e.g., processing plan data) or run other backend processes like creating a backup. To provide the best maintainability, quality, and robustness, some guidelines should be…
-
Level 200, Module 204
I'm at the mapping stage of H - Product Data Reader, and I can only drag the first item over and save. The remaining items (for product, product group, product category) 'bounce back' every time I try to bring them over. Wondering if anybody else is experiencing this.
-
Admin portal scheduled procedure error message
This error seems to be the default when a procedure scheduled from the admin portal fails. Would be useful if the error message was more descriptive of the error.
-
Anyone using version / code management software in BOARD projects?
Hey community, I just saw Bob Gill linking his article World Cup 2018 to a repository on GitHub (GitHub - grobertgill/Tournament: BOARD Tournament model setup for World Cup 2018 ). This is something I have been thinking about now and then but have never tried to do. Is anyone of you using such solutions (GitHub, Subersion,…
-
Overview ApiQuery calls (# of requests) in Cloud Administration Portal
Hi all, it would be wonderful to have an overview in the cloud admin portal how many API requests you actually use per day. Since there is a limit of 500 requests per day, this would help the customer understand if they need to think about increasing the limit soon. Thanks a lot!