-
Unable to Create a Cube or Go to the Relationships tab
Hi Team, One of the Partner Consultant had started with the Level 200 Course and he is facing issues while working in the trainingacademy board instance since last evening. He is unable to create any Cube nor go into the Relationships tab - Attached are screen shots received for reference.
-
More options in the BULK INSERT function
I think that the BULK INSERT function, has a lot of potential, whatsoever, it is very limited right now, it would help a lot to add more functions other than INSERT INTO. For example right now I'm trying to upload the hierarchies of our database to a SQL Database, if instead of INSERT we could also have access to the…
-
Option "Disable Unbalanced Hierarchy" should work "per block" and not on all the dataview blocks
We have switch our main entity "P&L" to unbalanced. This entity is used in hundreds of dataview. Some dataview are pretty basic and unbalanced is working as expected. However we also have a lot of medium / high complexicity dataview with hidden factors cubes, or tech cubes. In that case, some business cubes need to have…
-
% of total
How to calculate Value/(total value in column), % ------------------------------ Vasily Feofanov Analyst Limited Liability Company "Super Brands" Russian Federation ------------------------------
-
Group Leader Application
Are you interested in taking on a leadership role as a Board Group Leader? Group Leaders take an active and visible role in setting the tone and pace for their dedicated group. As such, we recommend Group Leaders have a minimum of six-months experience with Board software before applying. Co-leaders are also encouraged!…
-
Request a New Group
New Group requests will be considered when an appropriate number of members have been solidified and a Group leader has been identified. For example, a regional Group that is planning to have in-person meetups should have at least 10 customer accounts within a reasonable traveling distance of one hour. Please note that…
-
Group Leader Guide
The Community team would like to thank you for your interest and welcome you to the role of Group Leader! This role is an exciting leadership opportunity to bring together Community members around shared interests and geographic locations. Share tips and tricks, best practices, news, and accomplishments—all while providing…
-
Rest API - Run procedure with a selection
Currently it's possible to post argument to define the selection to the query you want to run as shown below : It would be very usefull to do the same to launch procedure when use to schedule. Documentation : https://www.boardmanual.com/subscription-hub/index.htm#t=1_Users/Client_API.htm
-
How to set up a 4-4-5 calendar
1. Abstract Board offers the possibility to create custom time entities in addition to the standard time entities to customize the calendar to specific business needs. Our goal will be to build a retail calendar based on the scheme of a 4-4-5 quarter, which is a method of managing accounting periods, mainly adopted by some…
-
Level 200 Module 207: Build a Data Model and Capsule Procedure to increase the CY budget by 5%
I might have missed it, but I think the instructions are missing the part where you should multiply py actual * 1.05 to get current year budget with 5% increase. In Level 200 207 shouldn't this have Set Expression to a*1.05? In the "MAIN" group, create a "Data flow" step, in "CONFIGURE LAYOUT" use "ACT - DF - Sales LC" as…
-
Board manual
Why is it that if i wan't to read about a specific feature (how something works) i need to read it at the release notes and not in the actual manual?
-
Default setting for Relationship
Hello, When there's a parent missing to a child, the Default button becomes visible. But if there are no errors, you won't see the button. Is it possible to set the Default mapping for each Relationship from somewhere else, even if there's nothing missing at the moment? Thank you
-
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…